Topic: MySQL Password

[zener]

Update:

I d/l the e-smith/phpmyadmin rpm and installed it but can't fing the config file to edit it (do I need to do this ?) where is this version of phpmyadmin installed in the directory structure, it's not in the html folder in the iBay.
When trying to acces it from a browser I still get:

#1045 - Access denied for user: 'root@localhost' (Using password: YES)

Help !

Newbie Alert !!!

I need to set up a PHP bulletin board system on my SME 6 server. I've copied over the phpmyadmin stuff and can access it from a remote browser elsewhere on the network (MacOSX) but it tells me that the user root can't access MySQL with password "NO"

I can't even access mysqladmin from the shell because I don't know the password, I tried adding a user with:

mysqladmin -u <name> password <secret>

I just get :

error: "Access denied for user: <name>@localhost (using password: YES)

I've configured PHP on several linux distros before so I'm not a complete virgin and I've edited the config file for phpmyadmin but I can't find anywhere any mention of the default password or even if one is used at all !

I tried admin and root users with and without passwords but no joy. The only FAQ regarding this is from version 5 and isn't relevant to my situation.

Please help !

Ken

[gardnc]

If you installed phpmyadmin from an rpm for e-smith then the folder is in /opt/phpMyAdmin.  It uses httpd authentication - meaning in this case system user names and passwords.

You should access it by https://yourserver/phpmyadmin - notice the lowercase phpmyadmin.  Use the admin login and password.

[ergozd]

File to edit for phpmyadmin
# /opt/administration/phpmyadmin/config.inc.php

mysql-root-password is stored in
# /root/.my.cnf

[jsk]

How to change the MySQL root password in SME Server:

http://www.familybrown.org/howtos/mysql-password-howto.html

-----------------
Best regards
John

[DanB35]

http://www.familybrown.org/howtos/mysql-password-howto.html