After installing phpMyAdmin cannot connect.

[ianw]

Hi All

I have installed phpMyAdmin (Via Synaptic) to work on a MySQL Database on PCLOS 2012-2.

When I click on the phpMyAdmin program on the Program Menu Firefox starts but gives the error...

"Unable to connect. Firefox can't establish a connection to the server at localhost"

MySQL is on the local machine and is running and I can work with it via the Command Line. And Firefox works 100% for accessing the Net.

Any idea what the problem is??

Thanks

IanW
Pretoria.

[Archie]

Check PCC (Configure Your Computer) > System > Manage system services ...

Check if httpd is running. Check if mysqld is running.

These two services should be running. If not start them up.

Then try phpMyAdmin on FF again.

[ianw]

Thanks Archie!!!

That was it!!

As I said - I had checked that MySQL was running OK but did not know about httpd. Once I started that phpMyAdmin started...

BUT - Now it complains about mysqli missing and will not let me into the program.

I don't find mysqli in the PCLOS Repos and all I can find out about it in the Net is that it is a php to SQL driver. Where do I get it and how do I install it?

The program also complains about not allowing Login without a Password but does not accept my standard Login Name and Password so where is this set??

Thanks again!!

[Archie]

Thanks Archie!!!

That was it!!

As I said - I had checked that MySQL was running OK but did not know about httpd. Once I started that phpMyAdmin started...

BUT - Now it complains about mysqli missing and will not let me into the program.

I don't find mysqli in the PCLOS Repos and all I can find out about it in the Net is that it is a php to SQL driver. Where do I get it and how do I install it?

The program also complains about not allowing Login without a Password but does not accept my standard Login Name and Password so where is this set??

Thanks again!!

We have it on our repository. Do a Synaptic search for php-mysqli.

On a terminal, (if you've never set a root password):

Code: [Select]

$ mysqladmin -u root password NEWPASSWORD
Launch FF+phpMyAdmin, login as root using the password you set on NEWPASSWORD.

Make sure you create your own db user, set a good password and assign privileges.

HTH

[ianw]

Thanks again Archie!!

Thanks for the "heads-up" to what the PCLOS Repo calls "mysqli". I got it and installed it!!

As I did have a Root Password I skipped the next step and tried to Login with 'root' and my password - NO GO!!

So I went back a step and set a new Password as you explained. Tried to Login again - STILL NO GO!!

Did a full system shutdown and restart - NO CHANGE.

The error I get is - "#1045 Cannot log in to the MySQL server".

I've checked... httpd and mysql ARE running.

Where to now and why is getting a new piece of software such a PITA!!!???

[JohnW_57]

Thanks again Archie!!

Thanks for the "heads-up" to what the PCLOS Repo calls "mysqli". I got it and installed it!!

As I did have a Root Password I skipped the next step and tried to Login with 'root' and my password - NO GO!!

So I went back a step and set a new Password as you explained. Tried to Login again - STILL NO GO!!

Did a full system shutdown and restart - NO CHANGE.

The error I get is - "#1045 Cannot log in to the MySQL server".

I've checked... httpd and mysql ARE running.

Where to now and why is getting a new piece of software such a PITA!!!???

Maybe this help you further: http://www.linuxquestions.org/questions/linux-newbie-8/cant-login-to-phpmyadmin-819842/
or google with: #1045 Cannot log in to the MySQL server

JohnW

[YouCanToo]

Please be aware that normally one does not have issues like this when setting up phpmyadmin from synaptic. I have setup many system over the past years with PCLOS and myphpadmin and have not yet once encountered the issue you are having!  This is not the norm.

By any chance did you use either a "@" or a "!" in your password when setting it up?  myPHPAdmin don't like them in a password.

You might try the following

in a console (terminal) window type in the following, where NEWPASSWORD is the password of your choosing.

$ mysqladmin -u root password NEWPASSWORD

and than login to phpmyadmin using 'root' and your newpassword.

If that doesn't work then you could change the config.inc.php file.  In a console window, as the root user, use the command

locate config.inc.php

you should see something such as

[root@pclosusers youcantoo]# locate config.inc.php
/home/members/linuxguy/phpmyadmin/config.inc.php
/home/members/scripts/php/myadmin/config.inc.php3
[root@pclosusers youcantoo]#

then open your favorite editor in superuser mode and edit the following line


$cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
                                                             // with 'config' auth_type)

you will need to add your password like this


$cfg['Servers'][$i]['password']      = 'MYNEWPASSWORD';          // MySQL password (only needed
                                                                                        // with 'config' auth_type)

Make sure there is a single quote mark on both sides of your new password.
Save the file and try logging into myPHPAdmin and see if that works for you

[ianw]

Thanks to everyone for helping.... only it's not!!

I've followed all the suggestions offered with still no luck. And now I can't even get into MySQL at the Command Line. I get the error...

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

I tried re-installing phpMyAdmin but no change.

What I have in my config.inc.php file is...

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['password'] = 'xxxxxx'; (This line I added)

Thanks as always!!

[inseine]

I followed this information to get mysql working.. see if it helps you

http://en.kioskea.net/faq/673-phpmyadmin-access-denied-for-user-root-localhost

[YouCanToo]

Thanks to everyone for helping.... only it's not!!

I've followed all the suggestions offered with still no luck. And now I can't even get into MySQL at the Command Line. I get the error...

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

I tried re-installing phpMyAdmin but no change.

What I have in my config.inc.php file is...

$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = false;
$cfg['Servers'][$i]['password'] = 'xxxxxx'; (This line I added)

Thanks as always!!

Since you are getting this error Access denied for user 'root'@'localhost' (using password: NO) have you tried using just root as the username and leaving the password empty?