Page 1 of 1

how to start using a locally installed MySQL server? - newbi

Posted: Tue Mar 23, 2004 2:01 pm
by davidklonski
Hello

I would like to learn how to start using MySQL.
I installed it locally on my Windows machine and I am reading the tutorial documentation that comes with it.

The tutorial says that in order to connect to MySQL I should use the following command:

mysql -h host -u user -p

Since I am running locally, I am assuming that I can skip the host part.

The problem is that I don't have a username and password yet. I just installed it.
How can I create one for me?
I read somewhere that I can connect as root. What does it mean?
I would like to create myself an acount with username and password so I could start working.
How does that relate to the grant command that I keep hearing?

please help
David

Posted: Tue Mar 23, 2004 2:15 pm
by andre_c
I would recommend using a graphical interface for it like mysql front, mysql cc, or phpmyadmin. Search for those in google.

Try one of those and then try to learn how to use it from php, look at the php.net mysql functions.

Posted: Tue Mar 23, 2004 2:25 pm
by Steveo31
Agreed on the PhpMyAdmin. I would also recommend EasyPHP.