Setting up a mySQL database on a local host

March 5th, 2004, 8:44 am

Hi,

I've got Apache running on my local machine (Windows XP Professional), which is great for trying out all those php scripts, but now I'm ready to get into more mySQL heavy code, but I don't actually know how to setup a mySQL server that I can access on my localhost.

Does anyone know how to set this up!? Thanks in advance to anyone that can help!

March 5th, 2004, 9:16 am

Setting up MySQL on Windows is fairly straight forward.

Download the current stable release of MySQL

<ol>
<li>Install the distribution.
<li>Set up an option file if necessary.
<li>Select the server you want to use.
<li>Start the server.
<li>Assign passwords to the initial MySQL accounts.
</ol>

The complete installation instructions are in section 2.2.1 Installing MySQL on Windows of the manual

Post again if you have any troubles with the manual.

March 5th, 2004, 10:31 am

Thanks a lot! I'll look into those.

In the meantime, I've been trying to connect to mysql with the following command:

mysql_connect (localhost, "myUserName", "myPassword");

which works fine, but is it possible to access the mySQL database from a php script running on a different server than the one mySQL is on? For instance:

mysql_connect("www.mydomainname.com", "myUserName", "myPassowrd");

The above code doesn't seem to work, at least, the access is denied. Is this a host-specific thing, or do I need to setup my mySQL in a specific way to allow this?

Thanks again

March 5th, 2004, 10:48 am

Yeah you need to add the hostname of the remote server to the access list..

Just setup phpMyAdmin locally (with the MySQL root account), and have a look in the "mysql" database. You can see there how users are in the access list for databases.

March 5th, 2004, 11:39 am

See the documentation for mysql_connect.

mysql_connect ( [string server [, string username [, string password [, bool new_link [, int client_flags]]]]])

March 5th, 2004, 3:15 pm

Thanks guys,

I checked with my server host, and they require that I inform them which hosts are allowed access to the database. Hopefully, when the time comes, they'll actually go and set it up for me...

At least its not something I can do something about (for the mo), but the advice/info is definately going to help me down the line