mysql GUI 1

[dvknn]

I am a novice in MYSQL.

I have windows 2000. I have downloaded the GUI binary version (1.7.5-2). I have to create a user and password.

I have created a DB, and tried to setup a user and passowrd. All my troubles started...

I did try to set up the user from winmysqladmin.exe.

I went into the 'winmysqladmin.exe' and in my.ini.setup,

[mysqld]
basedir=C:/mysql
datadir=C:/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
[WinMySQLAdmin]
Server=C:/mysql/bin/mysqld.exe
user=gneti
password=abcd

After this, I opened the GUI, and tried to set the user and password from the 'client' tab in 'options'.

ERROR 1045: Access denied for user: 'root@127.0.0.1' (Using password: YES)



COULD ANYONE help me SETUP a user and password????

Thank You,

 

[QatQat]

The user set up in my.ini is not a user for the database but the user that normally starts up the service.
Set it back to normal or to the user that normally logs in Windoz

If you started winMysqladmin then I supposed that you have already started Mysql as a service

You can check it on control panel, admin tools, services.

If it is correctly started you have to login as root without a password and then set all rights and create new users from there.

If the service is not listed open DOS prompt

c:\mysql\bin\mysqld-nt -install

Restart Windoz.

At DOS Prompt Log in as root

C:\mysql\bin\mysql -u root (press enter)

AT mysql prompt

GRANT ALL
ON *.*
TO ROOT@'LOCALHOST'
IDENTIFIED BY "yourpassword"
WITH GRANT OPTION
;

FLUSH PRIVILEGES
;


I suggest you read the documentation. Initial rihgts have to be set correctly so I recommend you don't attempt to use a GUI. AFter everything is set OK you may try MYSQL-front which seems to be the best. (it is advisable to never use a GUI)

Read this to create new users

http://www.mysql.com/doc/en/Adding_users.html

Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[kapplersvictory]

Hi Qatqat

Very clear and direct.
Why don't you guys write an article or something about installing and setting up MySQL on Windoz (as you call it)? It seems to be quite a recurrent problem.


Cheers


Kappler

 

[QatQat]

Hi Kappler,

I am sure many people have done it already.
I was anyway thinking myself to write a FAQ and post it on tek-tips. When I will put something together you can be sure I will call for assistance and input from other guys in the forum.

Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[QatQat]

I found this one posted by strella very recently


thread436-517320 have not read it myself but other users have posted positive comments about.


Bye

Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)

 

[dvknn]

I executed the following command (from DOS prompt)...and I got an error

mysql> GRANT ALL PRIVILEGES ON *.* TO gneti@localhost
-> IDENTIFED BY 'gayathri' WITH GRANT OPTION;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFED BY 'gayathri' WITH GRANT OPTION' at line 2.

I am using the 4.01.2 version.

In the documentation it doesn't specify any specific version. The only thing that it sys is that....this sysntax is applicable to versions above 3.0.23. So, I guess I am using the correct syntax.

Help me please..

 

[dvknn]

i executed

mysql> create database gaap;
Query OK, 1 row affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON *.* TO gneti@localhost
-> IDENTIFIED BY 'gayathri' WITH GRANT OPTION;
Query OK, 0 rows affected (0.49 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.52 sec)

Is there anyway to check if the user really exists in the table user?

Is there any documentation on the default 'mysql' database ?

Thank You,

 

[QatQat]

Log in as root

use mysql;

select * from user;


Will tell you what all users are.


Regarding Grant syntax

GRANT ALL
ON *.*
TO USER@'LOCALHOST' don't forget ' '
IDENTIFIED BY "PASSWORD" don't forget " "
WITH GRANT OPTION
;


Bye


Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)