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

13 06 2011

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๐Ÿ˜€ . 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๐Ÿ˜€ . 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.

XAMPP Status

XAMPP Status

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.

 


Actions

Information

31 responses

22 06 2011
Eric

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.

22 06 2011
Gihan

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.๐Ÿ˜€๐Ÿ˜€
please be kind to inform me that I’m right or wrong!..
Thanks..

22 06 2011
Eric

You’re RIGHT! I was able to log in and also my phpmyadmin works fine! You’re the man Gihan! Thank you so much!๐Ÿ™‚

22 06 2011
Eric

You’re RIGHT! I was able to access xampp and also my phpmyadmin works fine! You’re the man Gihan! Thank you so much!๐Ÿ™‚

22 06 2011
Gihan

You are welcome Eric..๐Ÿ˜€

29 06 2011
Nawras

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

30 06 2011
se7en

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

3 07 2011
Gihan

@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๐Ÿ™‚

4 07 2011
se7en

done! thanks!

4 07 2011
Gihan

๐Ÿ™‚ you are welcome se7en…

4 07 2011
Nawras

thank you very muchhh๐Ÿ™‚

4 07 2011
Gihan

you are welcome Nawras..๐Ÿ™‚

25 07 2011
Manish Munikar

i had tried to install LAMP before. When i goto http://localhost, all that is displayed is:
It works!

This is the default web page for this server.

The web server software is running but no content has been added, yet.

Then i installed XAMPP 1.7.4 exactly as you instructed. All the process went fine. But when i goto http://localhost it still displays the same page “It Works!”……
Why did this happen? According to you, it must have shown the XAMPP homepage. Did i need to uninstall LAMP before installing XAMPP? Now what should i do?

25 07 2011
Gihan

Manish Munikar, this is the actual XAMPP home page http://localhost/xampp/ . But normally when you go to http://localhost/ it automatically displays http://localhost/xampp/ . It’s not a problem I think. Try to run a simple php script on your localhost. Then make the decision whether its working or not๐Ÿ™‚ .Yes you should uninstall LAMP before do it. If you have any doubt feel free to ask and good luck with your work!

6 09 2011
Taner Temel

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

6 09 2011
Gihan

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

6 09 2011
Taner Temel

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

6 09 2011
Taner Temel

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

22 09 2011
Dav

Great help !!!

Thanks a lot !

David.

12 10 2011
yasser

thanks a lot .. u are a life saver๐Ÿ™‚
yasser.

29 11 2011
sourav

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!!

30 11 2011
Gihan

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.

30 11 2011
sourav

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!!

2 12 2011
Gihan

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.๐Ÿ˜€

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

5 12 2011
sourav

Brother you are great!!

25 12 2011
grenzfrequence

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?

28 12 2011
Denis

Wonderful description. Thank you Gihan!

9 01 2012
Kemar

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.

19 04 2012
hillary

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!

1 05 2012
aLtUuSh

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

4 10 2012
evan

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,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: