The Planet Forums > MySQL problems

Full Version: MySQL problems - fix does not work!

The Planet Forums > Control Panels > cPanel/WHM

krycek

Apr 19 2003, 07:10 PM

Anyone seen this?

QUOTE

MySQL 4.x upgrade If you are able to see all the databases on the server from phpMyAdmin after the MySQL 4.x upgrade you should run /scripts/updatenow;/scripts/fixmysql in a root shell as this will fix the mysql privilege table. For more information on this issue please review: http://www.mysql.com/doc/en/Upgrading-from-3.23.html

Well, I did that, and it did a load of stuff, but I STILL get the problem! People can see the dbs but not any data, but it's still a problem.

Any ideas?

::] krycek [::

Emrys

Apr 19 2003, 08:01 PM

Did you completely exit out of your browser and restart it? I found that I kept seeing everybodies databases until I refreshed the browser cache. Try that...

If not then there is some info on the cpanel forums about this. Sorry I don't have a link.

krycek

Apr 19 2003, 08:04 PM

Ah! Yep, it's fine now

Apparently the fix did work... but I had to physically log out of my session to update it.

::] krycek [::

amp3dmoshpit

Apr 27 2004, 09:18 AM

I'm new to this. Just got a new server and upgraded mysql to 4.0.18 from 3.23.56. When I try to create databases in phpmyadmin, i get access errors. So i saw I need to fix the privileges. I logged in through ssh and typed

root@domain root]# mysql_fix_privilege_tables

I get several denied access errors. When I try it with

root@domain root]# mysql_fix_privilege_tables -u root -p password

I still get denied access. I have been at this for over an hour. What am I doing worng. I know it's some basic mistake. Thanks for any help.

mickalo

Apr 27 2004, 10:37 AM

QUOTE

Originally posted by amp3dmoshpit
I'm new to this. Just got a new server and upgraded mysql to 4.0.18 from 3.23.56. When I try to create databases in phpmyadmin, i get access errors. So i saw I need to fix the privileges. I logged in through ssh and typed

root@domain root]# mysql_fix_privilege_tables

I get several denied access errors. When I try it with

root@domain root]# mysql_fix_privilege_tables -u root -p password

I still get denied access. I have been at this for over an hour. What am I doing worng. I know it's some basic mistake. Thanks for any help.

What steps did you use to upgrade MySQL from 3.* to 4.* ?? Did you totally stop MySQL and restart it, killing all processes ?? Did you try starting MySQL with the "--skip-grant-tables" ??

Mickalo

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.