MySQL permissions

[b4u]

Hi,

I'm no expert in MySQL administration, but I already made a few tricks on it. Now yesterday, I downloaded the lattest stable version available on the mysql site, and tried to configure some accesses on it ... with no success.

Software I downloaded (zip versions, no exe's, I like to have some control over it. oh, and windows version):

MySQL 4.0.22
MySQL Administrator 1.0
MySQL QueryBrowser 1.1.2

I created the following structure:

C:\Program Files\MySQL\MySQL\MySQL 4.0.22
C:\Program Files\MySQL\MySQL\MySQL Administrator 1.0
C:\Program Files\MySQL\MySQL\MySQL Query Browser 1.1

To each of the products. I went to the C:\Program Files\MySQL\MySQL\MySQL 4.0.22\bin, and installed mysql service with "mysqld --install-manual MySQL" ... and the service was installed with no problem (I want to manually start it, whenever I want to).

So it all went well and fine, until I tried the QueryBrowser ... I can connect with ANY user I throw at it ... beeing: root with no password, or beeing anything else with no password at all ...

Looking in the Administrator tool, I can create a schema, but when creating a user and given permitions to that new schema, the user still doesn't have access to the schema ... even if I set a password on that user, I can still enter QueryBrowser giving NO password, or a incorrect one, and it still accesses the query tool, with no access to the new schema I created.

But if I set a password to the root user (for example 123), I can't access without giving the correct 123 password, and it can access all schemas ... still the user I created has access only to "test" schema.

My C:\WINDOWS\my.ini :

#This File was made using the WinMySQLAdmin 1.4 Tool
#09-12-2004 8:38:35

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=C:/Program Files/MySQL/MySQL 4.0.22
#bind-address=
datadir=C:/Program Files/MySQL/MySQL 4.0.22/data
#language=C:/Program Files/MySQL/MySQL 4.0.22/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
#Don't allow new user creation by the user who has no write privileges to the mysql.user table.
safe-user-create


[WinMySQLadmin]
Server=C:/Program Files/MySQL/MySQL 4.0.22/bin/mysqld-nt.exe
user=administrator
password=admpass


Well, any ideas? I hope my explanation is clear ... if not, just ask stuff and I'll answer the best I can ... 🙂

Thanks

 

[b4u]

* bump of luck *

 

[kamper]

I usually grant permissions from the commandline. To do that you'd want to read up on the syntax of the GRANT statement in the manual and also at the installation section which goes over a few things regarding restricting root access and such.