How to install XAMPP on Linux (Ubuntu 11.04) Part #2

Ok this is the second part of the previous post.If you haven't read the first part "How to install XAMPP on Linux (Ubuntu 11.04)" please read it before come to this :D . Today I'll tell you how to configure MySQL databases (phpMyAdmin). Because config.inc.php is not set to your Linux username so,you are not still allowed to goto the phpMyadmin page.

First you should get open the terminal and login as root user.

Now press (Clrt+Alt+T) to open Terminal window
then type sudo -s -H

command: cd /opt/lampp/phpmyadmin

Now you are in the phpmyadmin directory, you need to change the ownership of the file config.inc.php to your own Linux username.

command:chown your_user_name:your_user_name config.inc.php

Ok now there is one thing to do.That's Configure Linux XAMPP Security

In this case too you need to login as root user(only if already logout).Now lets set up the security.

command: /opt/lampp/lampp security

Then the terminal will be ask some questions , type "YES" to all and set password to all. Important thing is write them down in a safe place.

After configuring security the database configuration file alteration automatically happened ,so  you need to change the ownership back to your username as did earlier.

command: cd /opt/lampp/phpmyadmin

command:chown your_user_name:your_user_name config.inc.php

Now you are done with configuring XAMPP :D . Restart the XAMPP with this command

command: /opt/lampp/lampp restart

Now check out your overall installation process. First you need to clear your entire browsing history and cache.

Type this on your browser : http://localhost/ then click on "Status" link. If all the things are done correctly, you will see a message like this.

[caption id="attachment_40" align="aligncenter" width="300" caption="XAMPP Status"]XAMPP Status[/caption]

Now you should be able to login to phpMyAdmin without any trouble. Login with your MySQL username and password that you gave at security configuration.

Important! :

  • phpMyAdmin has to accounts for MySQL as user names root and pma, but both have one password, that you gave. If login as root user, you will be able to have all privileges. But if you log in as pma user privileges will be limited and you are not allowed to create databases (only create tables and access the database).



  • Do not overwrite or delete default files inside your htdocs, becasue they are very important.If you do s XAMPP may be crashed.


webalizer
xampp
favicon.ico
index.php

If you have any doubt about any post feel free to comment and get solved tham.

Thanks

Gihan Malan De Silva.

 

Comments

  1. Eric22 June 2011 at 14:25

    Hi Gihan,

    I followed all your instructions. But when I tried accessing the localhost, it keeps on asking for a username and password. I tried the username root and pma with the password I set during the security configuration but it won't accept it. What could be the problem? TIA.

    ReplyDelete
  2. Gihan22 June 2011 at 15:54

    Eric, The user names "root" and "pma" belong to phpMyAdmin and not for the XAMPP pages, here when you set security for XAMPP you have secured your XAMMP pages with a password. When you trying to set passwords to the XAMPP, I thing you remember something like this, displayed on terminal:

    Your XAMPP pages are NOT secured by a password.

    Do you want to set a password? [yes] yes

    Password:

    Password (again):

    Password protection active. Please use 'lampp' as user name!

    So Eric, when you try to access the localhost , the username should be lampp and the password will be the one you gave. :D :D
    please be kind to inform me that I'm right or wrong!..
    Thanks..

    ReplyDelete
  3. Eric23 June 2011 at 04:07

    You're RIGHT! I was able to log in and also my phpmyadmin works fine! You're the man Gihan! Thank you so much! :)

    ReplyDelete
  4. Eric23 June 2011 at 04:08

    You're RIGHT! I was able to access xampp and also my phpmyadmin works fine! You're the man Gihan! Thank you so much! :)

    ReplyDelete
  5. Gihan23 June 2011 at 04:58

    You are welcome Eric.. :D

    ReplyDelete
  6. Nawras29 June 2011 at 21:17

    hi
    i have this error when I want to access phpmyadmin please could you help:
    PHPMyAdmin :: Existing configuration file (./config.inc.php) is not readable

    ReplyDelete
  7. se7en30 June 2011 at 13:21

    Existing configuration file (./config.inc.php) is not readable.
    what is this???

    ReplyDelete
  8. Gihan4 July 2011 at 00:59

    @Nawras & se7en : First of all sorry for delay, because I was busy with my academic. I think you both guys having same issue. This is happen with wrong configuration of config.inc.php file or you haven't totally changed the ownership of phpmyadmin into your linux user name.
    If you haven't done please do it with this on terminal..

    command:chown your_user_name:your_user_name config.inc.php

    It's better to read my two posts about xampp-ubuntu before do this. If you have any doubt, do not hesitate to ask. Thanks :-)

    ReplyDelete
  9. se7en4 July 2011 at 05:52

    done! thanks!

    ReplyDelete
  10. Gihan4 July 2011 at 15:48

    :-) you are welcome se7en...

    ReplyDelete
  11. Nawras4 July 2011 at 22:51

    thank you very muchhh :)

    ReplyDelete
  12. Gihan4 July 2011 at 23:46

    you are welcome Nawras.. :-)

    ReplyDelete
  13. Taner Temel6 September 2011 at 08:21

    thank you for a great step by step but when I try to access phpmyadmin I get the following error
    Wrong permissions on configuration file, should not be world writable!
    what chmd should this be and do you have a terminal comand to change this please.

    thank you in advance.

    Tony

    ReplyDelete
  14. Gihan6 September 2011 at 14:06

    Tony, I think you missed one step of procedure. To access the phpmyadmin you should have to change the ownership to your user account..

    I guess, you missed these things...

    login as root:--> sudo -s -H

    command: cd /opt/lampp/phpmyadmin

    command:chown your_user_name:your_user_name config.inc.php

    command: /opt/lampp/lampp restart

    Now check out your overall installation process. First you need to clear your entire browsing history and cache.

    Then try to log phpmyadmin

    If you still having any problems, tell me I will help you..
    Good luck with your work..
    Gihan

    ReplyDelete
  15. Taner Temel6 September 2011 at 20:55

    Hi Gihan thank you for your reply after clearing browser history I managed to see phpmyadmin. So the installation worked thank you but I have one other problem.

    After installing joomla on xampp I am getting an error message for strict standards on the front and back end of the site as below.

    Strict Standards: Static function JDatabase::test() should not be abstract in /opt/lampp/htdocs/17/libraries/joomla/database/database.php on line 350

    The same error starts from line 350 all the way to line 369.

    I have looked online for a solution and they recommend installing a older version of Xampp, but do you know of a way of correcting this issue without downgrading xampp?

    Thanks
    Tony

    ReplyDelete
  16. Taner Temel6 September 2011 at 23:49

    Hello again Gihan I have decided to down grade to xampp 1.7, I have got it installed on my computer and all seems to be working well. In your opinion what are the downside to having xampp 1.7 instead of the latest version?

    Thanks for all your help
    Tony

    ReplyDelete
  17. Dav22 September 2011 at 22:58

    Great help !!!

    Thanks a lot !


    David.

    ReplyDelete
  18. yasser12 October 2011 at 06:40

    thanks a lot .. u are a life saver :)
    yasser.

    ReplyDelete
  19. sourav30 November 2011 at 02:49

    Hi,
    I have installed xampp successfully in my Ubuntu system, I type this "sudo /opt/lampp/lampp start" and start xampp . I could see this on my terminal

    Starting XAMPP for Linux 1.5.3a...
    XAMPP: Starting Apache with SSL (and PHP5)...
    XAMPP: Starting MySQL...
    XAMPP: Starting ProFTPD...
    XAMPP for Linux started.

    but when I go and type in http://localhost I get a Unable to Connect message. I have also cleared my browser history and cache.
    please give some advice...thanks a lot!!

    ReplyDelete
  20. Gihan1 December 2011 at 00:01

    Hi, have you install lampp or xampp before on your computer, then that will also make some problems, if you haven't removed previous installation. Seems you've done something wrong, but I can't figure it out. Pls check you edit the httpd.conf correctly and extract the xampp-.tar.gz only by the command and not by the right clicking.

    ReplyDelete
  21. sourav1 December 2011 at 02:39

    Thank you for your inputs. Yes i have installed lampp and i extracted it by command.
    But as you have said i have not made any changes to the httpd.conf file...please tell me where the changes should go??
    thanks a lot!!

    ReplyDelete
  22. Gihan3 December 2011 at 02:46

    Then I think you've missed this. Pls remove your installation completely (command: rm -rf /opt/lampp) and then follow these instructions step by step, and before do it pls read the articles carefully. :D

    How to install XAMPP on Linux (Ubuntu 11.04)
    How to install XAMPP on Linux (Ubuntu 11.04) Part #2
    Some Useful important things about XAMMP for Linux

    ReplyDelete
  23. sourav5 December 2011 at 06:06

    Brother you are great!!

    ReplyDelete
  24. grenzfrequence26 December 2011 at 01:16

    For me mysql is disabled in status of xampp, but it was started from xampp. What is the problem? If i try to start an example in xampp, then the password is not found. Where do i have to enter the correct password to make xampp status working for mysql?

    ReplyDelete
  25. Denis28 December 2011 at 22:36

    Wonderful description. Thank you Gihan!

    ReplyDelete
  26. Kemar9 January 2012 at 20:25

    I followed your instructions and everything worked perfectly. Thank you very much for making this information available.
    This is my first attempt at this since I'm new to Linux so I consider myself an amateur and I was able to follow your instructions and get it done - that says a lot about the user-friendliness of this information. Thanks again.

    ReplyDelete
  27. hillary19 April 2012 at 16:31

    thank you for your help. My problem is that when installing joomla i cant go beyond database. i got this messages "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 29 SQL=CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL DEFAULT '', `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` TEXT NOT NULL DEFAULT '', `params` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), INDEX `idx_banner_catid`(`catid`) ) TYPE=MyISAM CHARACTER SET `utf8`" What is my mistake!

    ReplyDelete
  28. aLtUuSh1 May 2012 at 16:26

    hey gihan thanks for u, but i can't disable php Display errors. Help me

    ReplyDelete
  29. evan4 October 2012 at 16:25

    Hi Gihan, thanks for the tutorial of the installation. It works well.
    I'd like to disable the user authentication while opening the localhost. What should i need to do?
    Regards,

    ReplyDelete
  30. Anonymous6 December 2022 at 22:03

    Many games also include a wild image, which might take the form of any icon when wanted to complete 온라인 카지노 a profitable line. These are otherwise known as "multi-line" games and so they work similarly to buy-a-pays. You get determine on} how many of} traces you need to buy and how many of} credits you'd prefer to spend on each line. At a penny slot, you can spend 1¢ on the center line and take a spin.

    ReplyDelete

Post a Comment

Popular posts from this blog

Joomla 1.7 installation with XAMPP problem solved

Image
Hi, Recently Joomla 1.7 was released and obviously that is an excellent product. And new features also added. If you need any guide regarding installation these articles may help you , I think. How to install and configure Joomla 1.6 with XAMPP on Ubuntu 11.04 Though this is Joomla 1.6, there are not different between installation of 1.6 and 1.7, So thought not to add a new post on it. How to install XAMPP on Linux (Ubuntu 11.04) How to run XAMPP server on Windows with a flash drive..(portable XAMPP) In Joomla installation on XAMPP some guys are talking Joomla is giving some errors with XAMPP. Actually they are not errors, they are warnings. Is the nature of the software to give warnings. In standalone software solutions we normally do something called "error handling", right!. We need to care about Errors but we don't need to care warnings too much. So simply we can ignore them. Now the problem arises, "how to turn off the warnings", I think now I have ent...
Read more

Switching to a third party Domain Name System (DNS)?

Image
Hi everyone, today we will discuss on Domain Name Systems and usage of them. First lets see what is DNS? DNS stands for Domain Name System. And DNS is actually a database system that handle IP addresses and related domain names. When we type a web address and hit the Enter key, the ISP(Internet Service Provider) will look up the DNS for requested domain name. Then the DNS will return and direct to the correct IP address. Then we will see the requested web page. :-) Usually your Internet Service Provider maintains a DNS server for handle the DNS quires, so you don't have to worry about that. It hold a list of all the IP addresses and domain names within the network, and a cache of IP addresses which recently accessed computers outside the network.  This DNS servers are also responsible for your Internet speed. But sometimes you may realise your Internet speed is not enough. Most of the time this happens not because of your bandwidth but because of your ISP's slow DNS server. Bec...
Read more

A shell script for Renaming large number of files in Linux

Image
Hi, today I'm going to Blog about a very simple shell script, that may help you guys a lot.NO big deal, its very simple one. It was very helpful to me, once I had to rename a large number of images of Kim Kardashian.  So then I realise it will very easy doing it with a Shell script rather than manually rename it. #!/bin/bash # # Author: Gihan De Silva @  gihansblog.com # rename script # rename.sh clear x=0 for i in `ls *.jpg` do x=`expr $x + 1` mv $i Kim_Kardashian$x.jpg done echo "rename done!" Code Explanation! #!/bin/bash  This is how always a shell script starts. clear This line clears all the things already in the terminal window. x=0 This line define and declare a variable. for i in `ls *.jpg` This line starts a loop and, it will list down all the JPEG(jpg) type images. x=`expr $x + 1` This line increases the value of x by 1 . mv $i Kim_Kardashian$x.jpg This line renames all the files according to a sequence like, Kim_Kardashian1.jpg , Kim_Kardashian2.jpg, Kim_Kard...
Read more