mysql?

[lukeurtnowski]

I think I got it, I installed mysql
using the dos prompt, I find c:\mysql\bin
when I type mysql (to start it) I get a welcome to mysql monitor....
when I try to use mysql I get an error that tells me
access denied for user 'localhost' to database 'mysql'
Im lost???

[cornercuttinjoe]

it looks like you are trying to run as user 'localhost'.

google on how to set passwords for mysql accounts. i cant remember off of the top of my head, but i think this should get you in to mysql (this is what i use, but i am using linux)

mysql -u root -p -h localhost

try that, and if it asks you for a password, just hit enter. if i remember correctly, it will let you in since you havent set a password yet.

try that. hope it helps.

[thorpe]

did you run the mysql_install_db script? this is required to setup the default user tables. you will then also need to setup a user account for mysql.

[lukeurtnowski]

how do you run that? from the dos prompt? >mysql_install_db, I know the tables are there cause when I show databases, mysql and test are there. How do I set up a user account?

[thorpe]

check the manual