phpMyAdmin - Access denied!!
 

I'm using phpMyadmin and can't seem to log into the mysql server. I'm using the http authentication method. I've setup a control user - as per the documentation.txt that comes with it. I've created a 'root' user with 'password' and i can connect to mysql with the password but still i can't connect to mysql via phpmyadmin!!! Any hints/help please?

Thanx

Jack

You mean you can go

#mysql -u root -p
Password:

and when you type the password you can get into the text MySQL interface?

Oh yeah,

When you set up MYSQL, did you do something like this:

1. Install according to BINARY_INSTALL.TXT
2. Do chown -R mysql.mysql /var/lib/mysql
3. Go to /var/run
4. mkdir mysqld
5. chown -R mysql.mysql mysqld
6. Start the server - mysqld_safe --user=mysql & in the /usr/local/mysql/bin/
directory
7. Type in mysql -u root mysql
8. At mysql> prompt type
set password for root@localhost=password('yourpass');

Example:

[root@StefanLinux rylan]# mysql -u root mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 4.0.16-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set password for root@localhost=password('yourpass');

This works for me... I am assuming that is what you did BEFORE trying to setup PHPMyAdmin?

Yes, and i've done the whole OLD-PASSWORD('mypassword') thing aswell just in-case and done it without it and tried everything. I've also added another user 'mysql' with a password and still no luck :(

??

Not to worry, got it fixed! The answer was laying in config.inc.php
$cfg['Servers'][$i]['connect_type'] = 'socket'; and not tcp.

Thanx anyway.

Ek laik dit kwaai soos gesnyde kaas :)

Hiert! Hier is Afrikaners hier! HARDLOOP!