Gossamer Forum
(Advanced Search)
for
Home : Products : Others : MySQLMan :

upgrade to Mysql 4 problems

Apr 16, 2003, 8:26 PM
baidarkabob
User (182 posts)
baidarkabob's avatar
Apr 16, 2003, 8:26 PM
Post #1 of 6
Views: 5051
Shortcut
Quote Reply
upgrade to Mysql 4 problems
Greetings,

Server recently upgraded to Mysql 4. Now I can not see any Databases through Mysqlman. Any ideas?

bob


.:SEAWEAD:.
Apr 20, 2003, 9:50 AM
tsingson
User (114 posts)
tsingson's avatar
Apr 20, 2003, 9:50 AM
Post #2 of 6
Views: 4981
Shortcut
Quote Reply
Antwort: [baidarkabob] upgrade to Mysql 4 problems In reply to
visit the www.mysql.com and download mysqlcc to manage and repair your table.


so you can use mysqlman to connet mysql 4

my MSN: perlchina_at_hotmail.com
Apr 20, 2003, 11:30 AM
Paul
Veteran (19537 posts)
Apr 20, 2003, 11:30 AM
Post #3 of 6
Views: 4978
Shortcut
Quote Reply
Re: [tsingson] Antwort: [baidarkabob] upgrade to Mysql 4 problems In reply to
You can *probably* use myisamchk that comes with the mysql distro.

Last edited by:

Paul: Apr 20, 2003, 11:31 AM
May 6, 2003, 4:00 PM
Alex
Administrator (9387 posts)
May 6, 2003, 4:00 PM
Post #4 of 6
Views: 4924
Shortcut
Quote Reply
Re: [baidarkabob] upgrade to Mysql 4 problems In reply to
Is this a shared server? Most likely the ISP tightened permissions so that you no longer have access to view all databases (this was moved into a per user permission in mysql 4).

Cheers,

Alex
--
Gossamer Threads Inc.
May 6, 2003, 4:35 PM
baidarkabob
User (182 posts)
baidarkabob's avatar
May 6, 2003, 4:35 PM
Post #5 of 6
Views: 4914
Shortcut
Quote Reply
Re: [Alex] upgrade to Mysql 4 problems In reply to
Thanks for the reply Alex. This is not a shared server. Worse. I manage it.

The update came via a WHM/Cpanel update package. It is possible that somehow the permissions were tightened up via a new default setting in WHM. Can you advise me on how to check that?

bob


.:SEAWEAD:.
May 6, 2003, 4:48 PM
Alex
Administrator (9387 posts)
May 6, 2003, 4:48 PM
Post #6 of 6
Views: 4918
Shortcut
Quote Reply
Re: [baidarkabob] upgrade to Mysql 4 problems In reply to
=).. You need to look in the 'mysql' database, and check for 'Show_priv' is set to Y or N in either the 'user' or 'db' table. That column determines whether or not you can do a show database command and see other databases.

Cheers,

Alex
--
Gossamer Threads Inc.