Connecting to MySQL 5.1 with MySQL Tools 5.0

Submitted by Administrator on Thu, 06/04/2009 - 13:21
Tags:

 

 

 
- Download the MySQL Tools for 5.0 at http://dev.mysql.com/downloads/gui-tools/5.0.html
- You can install the tools on the machine with the MySQL installation or on a remote machine
- Just run the setup with default settings and use the Complete Install option  
mysql_tools1.jpg
 
When done with the installation you will be able to start the MySQL Administrator 1.2.17
- Enter Localhost for the Server Host or the ip address of the computer.
- Port 3306 will be used by a default installation make sure this port is open (Firewall)
- after initial installation only the root user account will give you access to the server
mysql_tools2.jpg
 

If everything went well you should be able to administer your MySQL server
- Select the option Catalogs click with the right mouse button on the list box Schemata and select 
  create new Schema, this way you can create and add a new Catalog to your database.
mysql_tools4.jpg
 

Add a user
- Select the option User Administration click with the right mouse button on the list box Users Accounts
  and select add new user, enter the User Information and set Schema Priviliges to your new user, this
  will create a user with priviliges on the created catalog it will also be able to connect to the server from
  a remote computer (for development purposes i created a user Administrator with all priviliges for the
  catalog).
 mysql_tools5.jpg

Comments

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img>
  • Lines and paragraphs break automatically.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.