Page 1 of 1

Help Installing MySQL

Posted: Sun Jan 18, 2004 12:01 am
by Decker87
Basically, I am at a part in a tutorial with the following instructions:
Do a typical install, and click finish. Open up a command prompt and navigate to the mysql/bin directory. Then, run mysqld --console. (Sorry, I forgot to take a screenshot. use "cd" to navigate directorys in dos)

We need a root password

Start another prompt, and type this:

code:
cd C:\Server\mysql\bin\
mysql> use mysql;
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> FLUSH PRIVILEGES;
mysql> QUIT
C:\> C:\Server\mysql\bin\mysqladmin -u root password rootpass
I can't get through the second line where it says:
mysql> use mysql;
I get this:
ERROR 1049: Unknown database 'mysql;'

Please help. First time installing, and I don't know what to do.[/quote]

Posted: Sun Jan 18, 2004 11:57 pm
by nigma
Maybe the db name is case-sensitive? try doing 'show databases' at the mysql prompt and see if there is a db with a similar name (i.e. 'MySQL')

Posted: Mon Jan 19, 2004 12:33 am
by kettle_drum
After mysql loads do:

Code: Select all

show databases;
to see if the database exists.

Posted: Mon Jan 19, 2004 12:40 am
by markl999
ERROR 1049: Unknown database 'mysql;'

..sounds like initdb hasn't been run *shrug*

Posted: Mon Jan 26, 2004 3:18 pm
by ol4pr0
1st: I would advice you to install mysql in c:\mysql. Youre manual has some information concerning installing in a differant path than c:\

2nd:
i would use mysql-front which you can get from this website. Its a nice program which avoids having you to type all the commands from the cmd.


http://www.mysqlfront.de/modules.php?na ... load&cid=1


cd c:\mysql\bin

and type mysqlshow will do fine 2 ;-) if i am not mistaken


to have it started from the cmd ( prompt )

net start mysql