User Create Bug?

[lukasbradley]

In attempting to create a new user, it does not appear as if the global user permissions are being saved. Furthermore, table level permissions are also missing.

I've attached a screenshot of the steps I am taking to create a user 'eventum'. The user is created, but they have no access to databases, and no permissions.

The first pic is creating the user (with global permissions selected), the second is editing the user (no global permissions showing), and the third is the user table (showing no global permissions).

Am I doing something wrong?

Lukas

[peterlaursen]

No problems here!

I thinks this is a misunderstanding ” Furthermore, table level permissions are also missing.”.

Table persmisons don't have to be set if gobal permissions are set!

But yes it seems you have a problem. What versions of sqlyog an Mysql are you using ?

I'm using Mysql 4.1.9 and tried two sqlyog version 4.0 Enterprise RC and 4.01 free version.

It could be an issue with your mysql installation. If you upgraded your present version from an earlier version, you should remember to run the script provided by nysql to reformat the user grant tables.

Try the tools form mysql (Mysql Administrator to create the user, Mysql Query Generator to process the sql, and see if the problem persist.

[lukasbradley]

peterlaursen wrote on Jan 20 2005, 10:03 PM:

But yes it seems you have a problem.  What versions of sqlyog an Mysql are you using ?

I'm using Mysql 4.1.9 and tried two sqlyog version 4.0 Enterprise RC and 4.01 free version.  

Sorry, I put the versions in the topic description. Should have also listed in post.

MySQL 4.1.8 and SQLyog Enterprise 4.01.

[lukasbradley]

peterlaursen wrote on Jan 20 2005, 10:03 PM:

It could be an issue with your mysql installation. If you upgraded your present version from an earlier version, you should remember to run the script provided by nysql to reformat the user grant tables.

I think that's an excellent guess. I don't know what the history of this server is, but I wouldn't doubt it has been upgraded.

I will test this, and post the results back here.

[leegold]

I am expericing what i think must be buggy behavior in the user grant display with 4.0.1 lite. DB specific user permissions are not being displayed correctly. While on the CMD line and PHPMYAdmin there is agreement…SQLyog is not showing the correct grants.

[mangumr]

I have the same problem. I am running MySQL 4.1.9-nt and SQLyog 4.01. SQLyog is attempting to modify the priv columns using lower case 'y' and 'n' but the columns are defined as enum('N',Y'). If I take the query from the history, change all 'y' and 'n' to 'Y' and 'N' then it works. Is this case sensitiviy issue strictly a Windows installation issue?

[peterlaursen]

Quote:

Is this case sensitiviy issue strictly a Windows installation issue?

It should be opposite. In MySQL case sensivity follows the standard of the Operating System.

That means that under Windows there is no case sensivity – under Linux/unix there is and under Mas OS-X it depends on the file system chosen at installation.

[jjmendezg]

i have the same problem

my test are done with a fresh install:

Mysql 4.1.8 WinXPPro Sp2 Box

Mysql 4.1.9 WinXPPro SP2 Box

Sqlyog Enterprise 4.0 Trial

the user is created without problems, but all privileges keep disable, so i had to enter directly to mysql.users and modify the privileges manually.

Thanks

[peterlaursen]

To both of you: Please answer the question:

Is the problem the same if you use “Mysql Administrator” ?

[Ritesh]

This feature seems to be effecting MySQL versions 4.1.8 and 4.1.9. Works great with v4.1.7.

No mention of such changes can be found at: http://dev.mysql.com/doc/mysql/en/news-4-1-8.html or http://dev.mysql.com/doc/mysql/en/news-4-1-9.html.

I am working closely with MySQL AB developers to know the exact reason.

Solution given by mangumr seems to be working though. 😀

[peterlaursen]

Still no problems here!

I'm running 4.1.9. And when logged on as ROOT or any user with GRANT privilege all sorts of user permissions are saved.

Do you all remember to press “apply” ?

[Ritesh]

Yes and I am able to reproduce the above error with 4.1.9-nt.

[peterlaursen]

I'm running 4.1.9 nt-max.

Matbe it's a workaround to change to the “max” server binary ??

[peterlaursen]

No that wasn't it!!

here it makes no difference which of the two binaries I use.

But actually I don't think I've run the script to update user GRANT tables when I installed 4.1.8 and 4.1.9. So maybe it's a problem with the script distributed with those version ?

[Ritesh]

peterlaursen wrote on Jan 26 2005, 04:44 PM:

I'm running 4.1.9 nt-max.

Matbe it's a workaround to change to the “max” server binary ??

Need to check this :huh:

[Ritesh]

We are proud to announce the release of SQLyog v4.02 BETA.

This release fixes the above bug.

You can download SQLyog v4.02 BETA from the following links:

Enterprise Edition: http://www.webyog.com/sqlyog/SQLyog402Ent.exe

FREE Edition: http://www.webyog.com/sqlyog/SQLyog402.exe

Can somebody confirm the bug-fix?

[peterlaursen]

With 4.0.2 User permissions works as it should here …

(but in my case previous versions did too)

[leegold]

No, still does not show correct DB specific user permissions!

The download you have a link to is missing the exe extension btw.

[Ritesh]

@leegold: Can you cut-n-paste CREATE TABLE… stmt. for mysql.user table? Case of 'Y' and 'N' will matter if the collation for the columns are *case-sensitive*.

Also, did you run *mysql_fix_privilege_tables* script on your MySQL server?

[lee]

I have experienced the same problems with user privileges not being saved or being deleted when using versions 4.1.8 and 4.1.9. I went back to v4.1.7 and everything started to work again. I’m looking forward to this being fixed. 😉

[Ritesh]

Did you try v4.02?

[jonathan]

Just tried sqlyog 4.02 beta with mysql 4.1.9 (on redhat). I can now set global permissions successfully, but still cannot set specific database, table or column permissions using the Manage Permissions screen.

[Ritesh]

SQLyog logs all the queries that it executes in the history pane. Can you cut-n-paste the query that SQLyog uses to set the privileges?

Can you provide us with create table statement of your mysql.user table?

[sitthichaikk]

The lastest 4.02 BATA version work fine on set user privileges, But Manage Permissions has problem below.

This is original line query from history.

Quote:

insert into mysql.db ( host, db, user, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, grant_priv, references_priv, Index_priv, alter_priv ) values ( '%', 'nn', 'nn', 'y','y', 'y', 'y', 'y', 'y', 'y', 'y', 'y', 'y' )

Quote:

insert into mysql.db ( host, db, user, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv, grant_priv, references_priv, Index_priv, alter_priv ) values ( '%', 'nn', 'nn', 'Y','Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y' )

After. I changed 'y' to 'Y' then do manual execute this query. It's work fine.

Note: This problem occured when I only use SQLyog remote to server.

[Ritesh]

We have released a new build of SQLyog 4.02 BETA that fixes this bug.

You can download the latest binary from the following links:

FREE Edition: http://www.webyog.com/sqlyog/SQLyog402.exe

Enterprise Edition: http://www.webyog.com/sqlyog/SQLyog402Ent.exe

With that I would like to say that this bug will only effects v4.1.8 and v4.1.9. There already exists a bug report which explains the issue you are getting:

http://bugs.mysql.com/bug.php?id=7617

[Ritesh]

Please download the latest binary and let me know the results.

[jonathan]

The new beta puts the correct database permissions into the mysql.db table, however there is still a problem with table level permissions and column level permissions

/*[15:56:09][ 0 ms]*/ insert into mysql.tables_priv (host, db, user, table_name, grantor, Table_priv ) values ( '%', 'test', 'jdw5', 'tab1', 'root@mysql0', 'select,insert,update' )

/*[15:56:09][ 0 ms]*/ insert into mysql.columns_priv (host, db, user, table_name, column_name, column_priv) values ( '%', 'test', 'jdw5', 'tab1', 'testtab', 'select,insert,update' )

Changing 'select,insert,update' to 'Select,Insert,Update' seems to do the job.

[Ritesh]

OK.

Got it.

We will be releasing SQLyog v4.02 FINAL on Monday that will have this bug fixed.

[Ritesh]

I am proud to announce the release of SQLyog v4.02 that fixes the above bug. Please check http://www.webyog.com/forums/index.php?act…&st=0#entry4488 for more details.

[ice]

😀

[peterlaursen]

sqlyog ver. 4.0.2 should be a ” fix for this issue”. Isn't it ?

[Ritesh]

Yes.

[computergenius]

Quote:

It could be an issue with your mysql installation. If you upgraded your present version from an earlier version, you should remember to run the script provided by nysql to reformat the user grant tables.

I have this problem on my MySQL 4.1.10 on Windows, with SQLYog 4.02 after a MySQL upgrade – and can see that I need to run mysql_fix_privilege_tables.sql – however, I have no idea where to find this file. It doesn't seem to be available on the internet as a single .sql file, and it appears that it should have been installed in binscripts, but it wasn't – there is no bin/scripts folder. Can anyone let me have the .sql file?

[peterlaursen]

It's in the /scripts directory placed in the directory tree under your mysql installation directory.

/program files/mysql/mysql server 4.1/scripts with a typical mysql installation.

However I have no problems with user privileges with mysql 4.1.10 and sqlyog 4.03 beta

[computergenius]

Quote:

It's in the /scripts directory placed in the directory tree under your mysql installation directory.

/program files/mysql/mysql server 4.1/scripts with a typical mysql installation.

Not on my standard “from the .exe” installation it isn't… 🙁

Although I have read in a number of places that that is where it should be, I have also read in a number of places that other people do not have it.

Any chance of a copy by email?

[peterlaursen]

yes i can mail it to you.

you can safely send your email to me from my personal homepage http://www.deepeter.dk .

I also try to attach it here: ( mysql_fix_privilege_tables.sql )

but there is a so-called wrapper-file ( mysql_fix_privilege_tables ) too – I really don't remmember if it is needed …

write again if you need help to search the mysql docomentation, but it seems like you know what you are doing 😉

[peterlaursen]

and here is the wrapper file

[peterlaursen]

I remember that there are two .exe distributions of mysql for windows:

a small one (“windows essentials”) and a “complete” one. Maybe it's the “windows essentials” distribution that you got ?

I am quite sure, that it also must be included in the version without installer !

[computergenius]

Quote:

I remember that there are two .exe distributions of mysql for windows:

a small one (“windows essentials”) and a “complete” one. Maybe it's the “windows essentials” distribution that you got ?

No, if I remember, mine was complete (allegedly!), because I needed the installer, because I am using an old version of windows.

Thanks for the file…

[Author]

Posts