Can not create database
i downloaded and installed MySQL, am at the part where it says "right click on the database section" etc. etc....
Only problem is i right click and all i can friggin get is a "flush hosts, flush logs, tables, threads? pop up.. what am i doin wrong? |
The newest version of mysql doesn't allow you to create a database like that. Instead, go to C:\mysql\bin and open mysql.exe.
Type: create database eq; Then your database will be made and you can go on through the rest of the steps :wink: |
Ty very much James =)
|
If you use the GUI for MySQL, as i think you do, there is a tiny bouton "SQL" thats is used to create a new DB.
|
Ok, I go in to the bin directory and open mysql.exe but before I can type anything, it dissapears. Can anyone tell me if I'm doing something wrong?
|
You have to open a DOS window and then go to the directory and type it, that will show the error you are getting from running MYSQL.exe. To do that:
Win9x: Go to run then type Command at the prompt, then browse to your MySQL\bin WinNT/2000/XP: Go to run then type Cmd at the prompt, then browse to your MySQL\bin |
Ok, I get there and now I get a message that says "Error 2003: Can't connect to MySQL server on 'localhost' (10061)"
I'm connected to a network, can I not run it from my computer but it has to be from the host? |
If mysql is installed correctly then you should be able to click START, RUN and type
C:\mysql\bin\mysqladmin create eq to make a database, and C:\mysql\bin\mysqladmin drop eq to delete it when you mess it all up and want to resource it :). You should do this on the machine upon which mysql is installed. The network should not matter. Hope that helps Pneu |
All times are GMT -4. The time now is 04:10 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.