Setting up mysql for the first time!

[SPYDERIX]

Hi,

I have just installed mysql on my machine for apache and I need to create a root user with a password and make it so that you can't login with user: root and pass: null and I want to be able to create users and passwords and only allow certain db's based on the user.

I have phpmyadmin and am familiar with inserting and deleting etc etc, but have never had to do this part, and I really need to know what to do. I am setting up PMA to cookie login but I need to set the user and pass for the root user as well as setup new accounts.

How do I do this?

I have been to phpmyadmin.net, php.net, mysql.com, and have checked my book, but everytime I try to change the password or create a new user I just get an error.

Thanks alot!

http://www.spyderix-designz.com

 

[SPYDERIX]

Hi,

I have figured out how to change my root password now and how the PMA structure works, but now I still don't see how I create a new user and pass in mysqladmin and what is host: % (do I need to keep those for hosts, or can I delete them?)

Thanks!

http://www.spyderix-designz.com

 

[tarn]

Simple:
just follow teh instructions here:

http://www.mysql.com/doc/en/Adding_users.html

Good Luck