Creating Database

[RudeYute]

Hi,

 

I'm required to set up MySQL on my XP machine in order to use an application I need.

I have tried installing the MySQL from their site, and installed fine, but configuring was a pain... have just installed WAMP to see if that's any easier.

 

Anyway, here's what I did (no errors with these commands, although I think i'm missing semi colons at end).

 

> mysql -u root -p

> CREATE DATABASE aw_hsc

> GRANT INSERT,SELECT,UPDATE on aw_hsc.* to username@127.0.0.1 identified by 'password'

> mysql -D aw_hsc -u root -p < hsc.v104.sql

> mysql -D fwevents -u root -p < hsc.v104.sql

> GRANT SELECT on fwevents.* to username@127.0.0.1 identified by 'password'

> GRANT SELECT, DELETE on fwevents.* to username@127.0.0.1 identified by 'password';

 

So it seems to have worked, but when I try connecting, the applications says it doesn't exist.

 

The commands I have used are from the user guide of the application I'm trying to use it with.

 

Can someone help me please?

 

Thanks

 

[wildteen88]

If you want to create a database just run the CREATE DATABASE command followed by your database name.

 

You don't need to run the GRANT command to set permissions on your database/tables. I know it gives added security however for now just set up the database and it's tables. Then go on to set up permissions.

 

Also if you have installed WAMP. You might find it easier using phpMyAdmin to create your database and tables for the application. You can use phpMyAdmin by opening a web browser and going to http://localhost/phpmyadmin or by clicking wamps task bar icon (looks like a rev-meter) and select phpMyAdmin.

[RudeYute]

Hi Dan, I did use the CREATE DATABASE command, but the application didn't see the database - database name, IP address, port and username and password were all correct.

 

As for WAMP - That's that I thought, but for some reason couldn't connect to anything on localhost or 127.0.0.1, not phpMyAdmin or MySQL.  Just got "could not connect message".

[wildteen88]

did you give it the correct database name?

 

I don't quite understand your WAMP comment though.

[RudeYute]

Yep, created right database name - Not sure if it was actually created tho - didn't get any response from the command.

 

If I go to http://localhost/phpmyadmin I just get "coould not connect" or similar message in my browser.

[bryandc]

This appears to be the same issue that Super Moderator Dan88 is terying to resolve for my PHP/Mysql installation on IIS.

 

No luck yet

[wildteen88]

You should get a reply like the following:

Query OK, 1 row affected

 

when you run

 

CREATE DATABASE aw_hsc;

 

Also can you post a screen shot of the error you get. I think you don't have wamp started and that's why you are getting that error. To start WAMP right click the wamp taskbar icon and select Start All Services options.