Problem with global user rights

[FineWolf]

SQLYog v4.0 Ent

mySQL Server 4.1

When adding or modifing the rights of a user, it seems that the rights are not saved correctly in the user table. Here is an example, if I create a new user called test, with some random password…. I'll give him select, update, & drop rights. Right after, I save. Instead of giving this:

Quote:

                Host: %

                User: test

            Password: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29

         Select_priv: Y

         Insert_priv: N

         Update_priv: Y

         Delete_priv: N

         Create_priv: N

           Drop_priv: Y

         Reload_priv: N

       Shutdown_priv: N

        Process_priv: N

           File_priv: N

          Grant_priv: N

     References_priv: N

          Index_priv: N

          Alter_priv: N

        Show_db_priv: N

          Super_priv: N

Create_tmp_table_priv: N

    Lock_tables_priv: N

        Execute_priv: N

     Repl_slave_priv: N

    Repl_client_priv: N

            ssl_type:

          ssl_cipher:

         x509_issuer:

        x509_subject:

       max_questions: 0

         max_updates: 0

     max_connections: 0

It saves this:

Quote:

                Host: %

                User: test

            Password: *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29

         Select_priv:

         Insert_priv:

         Update_priv:

         Delete_priv:

         Create_priv:

           Drop_priv:

         Reload_priv:

       Shutdown_priv:

        Process_priv:

           File_priv:

          Grant_priv:

     References_priv:

          Index_priv:

          Alter_priv:

        Show_db_priv: N

          Super_priv: N

Create_tmp_table_priv: N

    Lock_tables_priv: N

        Execute_priv: N

     Repl_slave_priv: N

    Repl_client_priv: N

            ssl_type:

          ssl_cipher:

         x509_issuer:

        x509_subject:

       max_questions: 0

         max_updates: 0

     max_connections: 0

Any known solution?

[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