Problem with global user rights

[peterlaursen]

What happens if you use MySQLAdministrator ( http://www.mysql.com) to define user privileges ??

Probably Ritesh can tell exactly what's happening here, but the tke user's schema has changed internally in the MySQL grant tables from 4.0 to 4.1 (and again from 4.1 to 5.0). I'm not quite sure that YOG is fully compatible with 4.1 (though it can be used for most tasks!).

Have you upgraded your current 4.1 MySQl from 4.0? If the answer is YES you must follow the upgrade procedure as described in the MySQL documentation. It won't do just to run the installer or replace the binaries.

I quote from the MySQL-documentation

“On Windows systems, there isn't an easy way to update the grant tables until MySQL 4.0.15. From version 4.0.15 on, MySQL distributions include a `mysql_fix_privilege_tables.sql' SQL script that you can run using the mysql client. If your MySQL installation is located at `C:mysql', the commands look like this:

C:> C:mysqlbinmysql -u root -p mysql

mysql> SOURCE C:mysqlscriptsmysql_fix_privilege_tables.sql”

(end of quote)

[FineWolf]

mySQL Admin doesn't let you set global rights. Well, I didn't see any way.

edit: It's well hidden, but it works

[peterlaursen]

well, it does .. if I understand you right !

See attched picture.

I'm talking about “MySQL Administrator” and not “winmysqladmin”

You can get “MySQL Administrator” from http://www.mysql.com (look in “developer tools”)

“winmysqladmin” that's still distributed with mysql is not useful here (and outdated too!)

I really do hope I understand you right !

[FineWolf]

Yea, problem was that you need to go in Administrator Option and check Show Global Privileges. I found it now and it works.

[Ritesh]

I have forwarded the issue to my development team.

[Author]

Posts