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

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
davidklonski
Forum Contributor
Posts: 128
Joined: Mon Mar 22, 2004 4:55 pm

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

Post 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
User avatar
andre_c
Forum Contributor
Posts: 412
Joined: Sun Feb 29, 2004 6:49 pm
Location: Salt Lake City, Utah

Post 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.
Steveo31
Forum Contributor
Posts: 416
Joined: Sun Nov 23, 2003 9:05 pm
Location: San Jose CA

Post by Steveo31 »

Agreed on the PhpMyAdmin. I would also recommend EasyPHP.
Post Reply