Problems with MySQL & PHPmyAdmin

[MuSQLe]

Hi there,

I am experiencing several problems configuring MySQL with PHPmyAdmin. I guess it's a typical user/pwd problem. Can somebody tell me where the config file for PHPmyAdmin is situated!?
(to configure PHPmyAdmin to use pwds and usrnames...)
I'm using RedHat 8 with PHP 4.3.0, MySQL 3.23.55, Apache2 2.0.44 and PHPmyAdmin 2.0.4-rc2.

OH, I guess, I just solved this...

Still I have problems configuring users in MySQL. I created a user called mysql with the password mysql. I granted access for this user to the MySQL directories and made the Dirs belong to this user. (with chown -R mysql /*dir*/)
When I try to start the DB with "./bin/safe_mysqld --user=mysql -p &" it would just not start. It says: "Starting mysqld daemon with databases from /usr/local/mysql/data
030218 14:10:16 (<= local time...) mysqld ended

[1]+ done ./bin/safemysqld --user=mysql
[bash...]

I'd be grateful for every bit of help/info... thanks

Tom

[nicc777]

Hi

First of all, there was a problem with MySQL connections on RedHat 8.0 a while back. I belief a fix has long being available, so just make sure you have applied all Glib and Glibc patches.

Next, your config file should be in config.inc.php where you installed the base of phpMyAdmin. Open this file in an editor ( vi ).

Look for the lines :

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';

You must make sure this matches your server settings.

With regards to adding users, look at:

http://www.mysql.com/doc/en/Adding_users.html

From what I understood in your mail, you just created a unix user, not a mysql user.

Hope this helps

Cheers

[MuSQLe]

Thanks for your reply, that helped.

I did not need the bug-fixes, I got this sucker runnig as is.
The user issue was a right guess, I just created Unix users and not MySQL users. This is i.m.o difficult to see, because the standard MySQL user is also called "root" and not "sqlroot" or something like that...