I am just starting to work with MySQL and I have it installed on a separae PC at my home as well. I downloaded and installed it, MySQL Administrator and the query analyzer as well. But I need to know how to create an initial database or does mysql come with a default database? I am asking because I tried to get in throughthe MySQL Administrator and it prompted for a database name initially that it can be linked to, but I realized there were no databases created. How can I create an initial database or is there some sort of utility window that comes with the MySQL download that I can access the database with? BTW, this is installed on Windows OS.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Starting MySQL Initially
- Thread starter bob120579
- Start date
In MySQL administrator, select Catalogues. You should see the Schemata window (bottom left). Right click within Semata and select Create New Schema. Name it as required and OK it. Right click on the new schema and select Create New Table. This takes you to the MySQL Table Editor - voila, you're in business!
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
- Thread starter
- #3
Yes. To enter Administrator just specify the connection. To start a new connection use the MySQL Server instance config wizard, which gets the server up and running. It gives you a basic setup with a default username of 'root' and a blank password. The default name for the server host is 'localhost'. When that MySQL instance is running, the Administrator will connect to that instance with 'localhost' as the Server Host, 'root' as the username and blank password. Port defaults to 3306. You should then be into the main section of Administrator. You will need to setup users first, then Catalogs (as previous post)
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
This stuff is also covered in Administrator Help. You can access Help via F1 even from the login page
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
- Thread starter
- #7
Ok, but here is the problem: I can't get past the inital window for MySql Administrator. The one with Stored Connection, Server Host, Port, Username and password. I used localhost for the Server Host, 3306 for the port, and root for the User and no password and it gave me the message: "Could not connect to the specified instance" Is there a step that I missed after downloading and installing MySQL??
Is the server actually running? On your local machine?
Run the MySQL system tray monitor (if it's not already running) and check that it's actually running.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Run the MySQL system tray monitor (if it's not already running) and check that it's actually running.
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
- Status