Help Installing MySQL

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
Decker87
Forum Newbie
Posts: 3
Joined: Fri Oct 31, 2003 9:13 pm

Help Installing MySQL

Post 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]
User avatar
nigma
DevNet Resident
Posts: 1094
Joined: Sat Jan 25, 2003 1:49 am

Post 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')
kettle_drum
DevNet Resident
Posts: 1150
Joined: Sun Jul 20, 2003 9:25 pm
Location: West Yorkshire, England

Post by kettle_drum »

After mysql loads do:

Code: Select all

show databases;
to see if the database exists.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

ERROR 1049: Unknown database 'mysql;'

..sounds like initdb hasn't been run *shrug*
User avatar
ol4pr0
Forum Regular
Posts: 926
Joined: Thu Jan 08, 2004 11:22 am
Location: ecuador

Post 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
Post Reply