[SOLVED] MySQL starts? Now what?

[Skipjackrick]

So, I installed MySQL version 5.1, Apache 2.2, and php 5 on Windows XP.

 

I am trying to use phpmyadmin and it doesn't work.  I dropped the phpmyadmin files in my root directory and opened up the phpmyadmin/index.php file and I get this error.

 

phpMyAdmin - Error

Cannot load mysql extension. Please check your PHP configuration.

 

Here are a few questions.

 

How do I know my MySQL is working properly?  Is there a way to test it?

 

I tested php and it works fine using a test program.  Next, I need to create a database and define users, and passwords, tables etc in MySQL but I have no idea how to do this using mysql.  I have always done it using phpmyadmin through the web.  I am trying to install this locally on my computer so I can test things faster. 

 

What do I edit in my PHP configuration?

 

Can anybody help me out?

[trq]

How do I know my MySQL is working properly?

 

Connect to it via its command line interface. Open cme.exe and type...

 

mysql

 

Next, I need to create a database and define users, and passwords, tables etc in MySQL but I have no idea how to do this using mysql.  I have always done it using phpmyadmin through the web.

 

This can all be done via the same command line interface, most people prefer however to have some point and click option.

[Skipjackrick]

 

This can all be done via the same command line interface, most people prefer however to have some point and click option.

 

Yeah, that's what I need.  I've been trying to install phpmyadmin.

 

I believe mysql is working properly because I can pull it up in a command prompt.

 

what would be the command to create a db?

 

Same as Php?

 

mysql_create_db("sharkathon") or die(mysql_error());

 

Nope apparently not.

[trq]

Same as Php?

 

mysql_create_db("sharkathon") or die(mysql_error());

 

Nope apparently not.

 

mysql_create_db is a php function not a command of any kind.

 

The mysql command line interfaces expects sql statements and simple commands. It shows you a help message when you first login.

 

CREATE DATABASE foo;

[Skipjackrick]

CREATE DATABASE foo;

 

Ah, thanks....working now.

 

Sometimes its so easy its stupid.