Creating a db in MySQL

[adaykin]

Hello, when I create a database in phpMyAdmin, how do I set a password? And is there another way to create a database besides using phpMyAdmin? Also what is the database username? Is it just root?

[LooseCannon]

Remember to BackUp.

User accounts & passwords

You'll be wanting to get to grips with Privilages.

On the phpMyAdmin Home page, there's an icon called Privilages. Have a look in there, but take great care!

Note that Privilages can relate to users and/or databases and/or tables.

Lots of reference info at http://www.mysql.com/ and in particular http://dev.mysql.com/doc/refman/5.0/en/ ... ystem.html

Other ways of creating databases

Again, check http://www.mysql.com/. When you start to get familiar with MySQL, I think you'll see that phpMyAdmin does the job nicely.

Otherwise, maybe have a look at SQLyog. http://www.webyog.com/

Backup

Remember to.

It's really frustrating to loose access by mistake....... Never happened to me of course.