Setting up your username and password - MySQL

[martinb7]

Hi, i have just got MySQL (version 4) and I don't know how to set up a username and password.

Does anyone know?

HELP!!

Martin

 

[vbkris]

do u mean a username and pwd for mysql?
i havent done it till now.

Known is handfull, Unknown is worldfull

 

[martinb7]

yes thats what I mean. If I don't have a proper username or password, it comes up with a error: unable to connect blah@blah.

how did you set it up?

 

[sleipnir214]

You set up usernames, passwords, and access addresses in MySQL through the use of the GRANT statement

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

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[aniruthan]

go to <drivename>:/mysql/bin/ where drivename is the drive where you have installed mysql and run (double click) the mysqladmin.
In that select myini.Setup where you can change the username and password and save modification.

 

[aniruthan]

sorry. it is winmysqladmin

 

[DRJ478]

martinb7

If you do not setup a password then you probably connect as the root user who was created by the installation.

There is a good reason why the documentation advises everyone running MySQL to immediately set a root password as soon as the installation is done.

Why? If you can access the server at root level without a password, so can everyone else that find his/her way to the server. No password, bad idea.

The root user can wipe out all databases. Would you like anyone from anywhere to be able to do that? Probably not.

You can create users at the command level by manipulationg the user table records in the mysql database. Be restrictive for your own good.