Topic: Mysql problems

[Ed]

Just upgraded to SME 5.6 unsupported. Updated to glibc-common-2.2.5-43.i386.rpm and glibc-2.2.5-43.i386.rpm.

Using phpMyAdmin I get the following error:
Error
MySQL said: Access denied for user: 'root@localhost' (Using password: YES)

If I try to go to the phpBB Forum Admin page I get the following error:

An Error Occured
--------------------------------------------------------------------------------
phpBB was unable to connect to the database.
Please check $dbhost, $dbuser, and $dbpasswd in config.php.

I also cannot connect using Navicat ... I think its a password issue??
Is there somewhere I can change this?

[Craig Jensen]

Your root password may have been changed.  Search the forums for 'resetting root password'.

Also: http://www.mysql.com/doc/en/Resetting_permissions.html

Regards

Craig Jensen

[Ed Burgstaler]

Thanks for your help Craig ... that fixed it.

[Ed Burgstaler]

Forgot to mention though that my GUI administration Navicat still cannot connect to Mysql database although everything else seems fine now. Still says cannot connect to host ... it will not accept the root username and password for Mysql.

[Dan Brown]

Are you sure you're using the _mysql_ root password?  For more info, see http://www.familybrown.org/howtos/mysql-password-howto.html.

[IDar]

I have updated both glibc-common and glibc but for mistake i downloaded the RH9  files instead of the update ones... and naw i can't neither use my mail server nor use my server correctly...

I can't or I don't know how to make a rollback or install the right type of RPM's...
¿what can I do?

[IDar]

When i try to install the RPM's i get:

[root@localhost]#  rpm -Uvh --replacepkgs  glibc-2.3.2-27.9.i386.rpm glibc-common-2.3.2-27.9.i386.rpm
Preparing...                ########################################### [100%]
Segmentation fault

[Ed Burgstaler]

PhpMyAdmin works fine but I want to use Navicat and I cannot seem to get it working. If I use your suggestion Dan, I am then locked out of everything and phpmyadmin no longer works nor does forum access. Though I am then able to logon to mysql from the localhost.
I end up having to set the password for root back to what it was previously to get everything working again exept here are the results when I type mysql at the server:

Welcome to the Mitel Networks SME Server.
[root@mail root]# mysql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
[root@mail root]#
 
Any other ideas as to why Navicat doesn't work? Thanks

[Dan Brown]

...then it sounds like you've changed the mysql root password, and then set the changed (i.e., wrong) password in some of your other apps.  Your forum shouldn't be using root at all.

What do you mean by "locked out of everything"?

[Ed]

Well what I mean is that if I follow your instructions to change thr root password in Mysql then I am able to just type Mysql and I can list the databases.
The problem is that I can no longer access Phpmyadmin or the forum I have set up and even so Navicat still cannot connect to Mysql from my XP workstation even though I am using root with new password to logon. It just states "cannot connect".
So I go back and change the Mysql password for root back to what it was before and then I can no longer just type Mysql at the server prompt to access databases and low and behold I am now able to access my forum administration and Phpmyadmin.
Does any of this make sense?

[Dan Brown]

Yes, it makes perfect sense.  You changed the mysql root password (which you shouldn't have done for the reasons I previously outlined), and then used the root user and changed password when you set up phpmyadmin (which you needed to do) and your forum (which you shouldn't have done; the forum doesn't need root access).

What you should do is:

1.  Reset the mysql root password as described in my HOWTO.

2.  Change the phpmyadmin config to use the new mysql root password.

3.  Change the phpbb config to use a completely different user and password--there's no need to use root for this application, and if a security vulnerability in phpbb were to allow the config files to be read, using root would compromise that name and password, exposing your whole database rather than just one set of tables.

Now, as far as Navicat, I've never used it and don't know much (read: anything other than what I see in about 30 seconds on their web site) about it, but I don't think the mysql root user allows remote access by default.  This could be your problem.

[Ed]

That makes a lot more sense now ... btw where is the phpmyadmin config file located? Thanks for all your help Dan....

[Dan Brown]

Well, it's located wherever you installed phpmyadmin.  If you installed it as an RPM, do

rpm -ql name-of-rpm | grep config.inc.php

to find out where it is.

[Ed Burgstaler]

I cannot find the Mysql password in the my.cnf file all that is stated is user=mysql

[Dan Brown]

...and you're sure you're looking at /root/.my.cnf?  It sounds like you're looking at /etc/my.cnf instead.