Topic: phpmyadmin problems in SME5

[Frank]

Since the root password in /root/.my.cnf is encryped in SME5, do anyone knows how to read this password so that it can be set in config.inc.php in phpmyadmin 2.2.0?

After upgrade MySQL to version 3.23.42-1 based on Mark Fleeson's How-to document (http://www.e-smith.org/docs/howto/contrib/mysql-upgrade-howto.html), I found that the rpm for mysql remains on 3.23.32-1.7 but there are new MySQL rpms being installed. The phpmyadmin 2.2.0 then shows garbage and cannot access the mysql database anymore.

Does anyone have solutions? Thanks in advance.

-Frank-

[Frank]

Pls ignore my part 1 question as I found in this forum that the password is the exact random string, not encrypted. Any comment on part 2? Tks.

[gerald]

Why on earth did they change the mysql password to 75 characters. Crazy especially when I setup a lot of post-nuke portals. Can't copy and paste in MC. Is there a simple command line sequence that will allow changing the password to a size that is more manageable?

[Ari]

gerald wrote:
>
> Why on earth did they change the mysql password to 75
> characters. Crazy especially when I setup a lot of post-nuke
> portals. Can't copy and paste in MC. Is there a simple
> command line sequence that will allow changing the password
> to a size that is more manageable?



[root@localhost root]# mysqladmin -u root password

= whatever you want the new password to be.

Cheers!
Ari

[Randy Brown]

Instead of using the 75 characters for root password why dont you creat a new mysql user that can accecess the database. With the new phpmyadmin it is very simple. This also prevents anybody from easly stealing your root password from config.php.

This was one of the nice changes 2.2.0
added.  From the main page > Users > Add a new User.  Very easy to use.  
Link to mySQL online documentation included


Hope this helps

ps:
I am clueless about mysql, but thanks to Darrell May and Dan Brown I had no problems doing this.