Security

[weronpc]

I installed mysql (OS: Window XP)

Right now I can access to MySQL Database without username and password, how can I create a username and password?

eg.
In php, right now I can do this: connect($local_host);
but I want it to be like this: connect ($local_host, $username, $password);

Do I have to download any administrator software for that?

Thank you,

Mike

[raf]

Yes, you can us the commandline interface for that (dos-session)

If you have not set a password, do
mysqladmin - u root password "yourpasword"
(include the quotes !)
if you have set a password, do
mysqladmin - u root -p status
You will then be prompted for your password


check out the post-installation section of this article for more info:
http://www.mysql.com/articles/ddws/index.html

[Spookster]

Or if you prefer a graphical interface you can use phpMyAdmin which has a section for creating and managing users of your database.

[weronpc]

Raf:
What about user name? do I do this? mysqladmin - u root username "myusername"
I am not really good with DOS command, what is -u root mean?

Spookster:
phpmyadmin? do you know where can I download it and what version is the latest version? I am thinking about chaning my OS to Linux, does it work on Linux?

Thank you both so much...

Mike

[Spookster]

phpMyAdmin will run on any machine running mysql and php

http://www.phpmyadmin.net/

[raf]

weronpc,

If your not good with commandlines, then best install a db-frontend like phpMyAdmin (the standard frontend for most MySQL users) or MySQL-front (my personal favorit).

When tou install MySQL, theres created a user called 'root', which has administrator rights for the MySQL server and all db's.
The first thing you should do after installation, is set a password for this user !!!!
what is -u root mean
U stands for username, root is the username you want to login with.