PDA

View Full Version : [ubuntu] jaunty upgrade, can't connect to mysql



gleble
June 26th, 2009, 11:33 AM
Since I upgraded to Jaunty I have not been able to access phpmyadmin which I get to through Xampp. I'm sure it's a configuration matter but I don't know where to go.

gleble
June 26th, 2009, 06:03 PM
I have got into phpmyadmin now but wordpress and drupal say thry are being denied access. I know the server is 'localhost' and username is 'root' how do I discover/change my password?

cmwslw
June 26th, 2009, 06:07 PM
can you please post more specific info like the exact error messages?

gleble
June 26th, 2009, 06:25 PM
phpmyadmin has a warning that says 'Your configuration file contains settings (root with no password) that correspond to the default MySQL privileged account'.

Wordpress says 'Error establishing a database connection'
Drupal says 'The mysqli error was: Access denied for user 'root'@'localhost' (using password: YES).'

Both let me in before the upgrade

jimv
June 26th, 2009, 06:53 PM
First off, install MySQL Administrator to make things easier:

sudo apt-get install mysql-admin

Then open it in Applications > Programming > MySQL Administrator and see if it will let you connect. If it can, go to the User Administration section, and click on the root user (bottom left). You'll see @localhost listed below, click on that. Then on the right, you'll see "schemas" listed...these are your databases. Make sure that the necessary permissions are assigned for your databases to allow root to access them.

gleble
June 26th, 2009, 07:30 PM
Installed MySQL Administrator When I try to connect I get

Could not connect to host 'localhost'.
MySQL Error Nr. 2002
Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

It lets you test the ping and it does ping

jimv
June 26th, 2009, 10:41 PM
if you go to /var/run/mysqld is there a file called mysqld.sock?

gleble
June 27th, 2009, 10:06 AM
Yes there is now because I downloaded mysql-server and mysql-client. Now I can get into MySQL Administrator but not phpmyadmin and I still have the database access problem with wordpress and drupal. I'm getting more and more confused, can anybody sort this mess out?

gleble
June 27th, 2009, 11:10 AM
Checked the database on mysql ad it only shows mysql and information_schema. Where are my other databases?

gleble
June 27th, 2009, 05:57 PM
I've noticed that Xampp is not starting sql. Any ideas why not? Surely this problem is linked.