Hi All,

I'm trying to install Mysql on a window 2000 server but can't seem to figure out how to use Mysql?

Where do I go to find the username, password, host name(is this the server ip) for mysql on ther server?

If I can't find this, where can I go and setup the username and password for Mysql?

I'm trying to setup VBulletin and I basically don't have any knowledge of PHP or MySQL

Please help!


Thanks,
Linda

The values which you can use to test it are 'root', '', 'localhost'. Then use any tutorial from any search engine.

VBulletin has a great tech support forum, you should try asking there too.

Once you have installed MySQL -- run winmysqladmin.exe from the MySQL bin directory.

If you installed MySQL in c:\mysql, then this file is c:\mysql\bin\winmysqladmin

This file will launch a monitor for MySQL (it will also let you set a password). Default installs of MySQL don't have a password for the admin account.

Once this file is launched, you will see a traffic light icon on your system tray (where the clock is). If this light is green, you MySQL server is running, if its red, its stopped.

One other benefit for running this utility is that after its initial launch, it automatically starts up when the computer boots so your MySQL server will be running.

After you have your MySQL server running, consider downloading some third party management tools (there are two published by MySQL AB -- both free, check the download section for clients).

Download PHPMyAdmin and configure it with IIS (execute .php files with php4isapi.dll).
open it up with your Internet Browser, enter user name (root) and password, and there you go..

"MySQL Control Center" could also be used for the same job if you don't know how to configure PHP on your server.

Hi linda - if by some chance you are familiar with communicating with MySQL via telnet or SSH then you can use the Windows Command Prompt to talk to MySQL just like you would telnet/ssh into a remote server (Linux, Windows) and "talk" to MySQL that way. You can also set the initial password this way by typing a one line command.

From inside Windows here's how you would access MySQL this way:

1) launch a command window by going to: START->ALL PROGRAMS->ACCESSORIES->COMMAND PROMPT

(you can also get to it by going to START->RUN and typing: cmd

2) inside the Command Prompt window type: cd c:\mysql\bin
(or change directory to the location that you installed if you didn't use the default install location)
3) if you don't have a password set yet, then you can set it easily by typing the following:

mysqladmin -u root password new_password

where new_password is the new password that you would like to use

4) next, when you have already set a custom MySQL root password (step #3) then type: mysql -u root -p

PROBLEM #1: if you receive a message asking for your password then enter the custom password (you'll see asterisk instead of the password). If for some reason you can't figure out the password you can reset it by following the instructions here: dev.mysql.com/doc/mysql/en/Resetting_permissions.html

PROBLEM #2: If you receive a message that indicates the MySQL server isn't running then you can start the MySQL service from within the Command Prompt by entering the following: net start mysql -- you can also see a list of all running NET services by typing: net start

5) next, if the MySQL server is running and you entered in your password correctly you should now be set to communicate directly with the MySQL server from the Command Prompt just like you would if you were telnet or SSH to MySQL on a server. The command prompt should look like this now:

mysql>

You can now look at your available database by typing: show databases

########
From this point you should be able to create new databases, access existing databases (the command to use is USE databasename), create tables and do anything else.

Personally I like communicating with MySQL this way as opposed to using other interfaces but then I'm a bit old school. Hope this helps!

Happy coding to you!