WAMP/SQL help

InvaderGIR · 7 Jun 2008 at 14:39

I'm trying to quickly and easily set up a local webserver on my 2nd PC so that I can test out site creations without having to upload them to the web, and I have been pointed towards WAMP.

Now it does what I want, has PHP SQL etc. running, but I can't for the life of me remember how to create users for the SQL database other than the root user. On my website's control panel I can just tell it to create a new table and create new users that can write to the table etc. but PHPMyAdmin doesn't seem to want to let me do anything like that. I can create new tables, but the only users are 'root'.

Also on the PHPMyAdmin main page it tells me root has no password and to edit the config file...now I've only found one that I can see would be the right config file, and it isn't as adding a password does nothing.

InvG

Moredhel · 7 Jun 2008 at 15:00

you do it in MySQL itself. The query to create a user for a specific database would be

Code:

GRANT ALL ON dbname.* TO 'user'@'host' IDENTIFIED BY PASSWORD('mypassword');

Run it through the MySQL cli or PHPMyAdmin. Host can most probably be kept as localhost unless you intend to access the DB remotely.

Clarkey · 7 Jun 2008 at 15:17

MySQL GUI Tools http://dev.mysql.com/downloads/gui-tools/5.0.html

You can set up users and databases super easily with MySQL Administrator.

Moredhel · 7 Jun 2008 at 16:30

Or just type a single line and not need to install anything else.

InvaderGIR · 7 Jun 2008 at 17:37

I tried that line, it didn't like it. But then I've forgotten where to put it exactly. It's been ages since I used MySQL or PHPMyAdmin, so don't know where to enter stuff or how to use it.

EDIT: Also I don't really want to have to install multiple things, having WAMP contain it all makers life easier, rather than having SQL, Apache, PHP all installed separately over the machine.

InvG

Jotun · 9 Jun 2008 at 19:44

If you browse to phpadmin - http://localhost/phpmyadmin/ and then click "Privileges" it'll take you to a page where you can edit the root password with the icon on the right, and create new users. Hope that helps

InvaderGIR · 9 Jun 2008 at 20:15

Uh oh...I broke it.

Looks like I didn't click enough things to find the users area.

I've now changed the localhost password...which is great...apart from now I can't get on it because it requires a password and has no login...oops. I think I'll just reinstall it.

InvG