I have zero experience, really, with Mysql although I compiled it on a Linux box and
it works well for a couple of sites and messageboards that I host from my house. I do
this strictly for fun and would like to let some friends and family members have
websites as well.
Here's what I don't
Briefly:
http://dev.mysql.com/doc/mysql/en/GRANT.html
GRANT ALL PRIVILEGES ON dbname.* TO user IDENTIFIED BY 'userspass';
CREATE DATABASE dbname;
\q
mysql -u user -p dbname
Password: userspass
mysql
NEVER *EVER* run ANYTHING using root. That's an administrative only user.
Some applications may