Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: zener on July 02, 2005, 01:20:21 PM

Title: MySQL Password
Post by: zener on July 02, 2005, 01:20:21 PM

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

Title: MySQL Password
Post by: gardnc on July 02, 2005, 02:48:07 PM

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.

Title: MySQL Password
Post by: ergozd on July 02, 2005, 07:05:21 PM

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

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

Title: MySQL Password
Post by: jsk on July 06, 2005, 09:14:59 PM

How to change the MySQL root password in SME Server:

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

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

Title: MySQL Password
Post by: DanB35 on July 07, 2005, 04:58:12 PM

Quote from: "jsk"

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

 ;-)