Just installed Mysql and have root user access... now what?

[wilsonpaul]

I just had mysql installed and know the root user password. But I can't seem to create databases using phpmyadmin or shelling into the server.Do I have to create another user and create databases for it? If so how?<br /><br />Thanks.<br /><br />BTW... for the first time ever I have a couple of dedicated servers to play with so I have alot of things to learn and stupid questions to ask <img border="0" title="" alt="[Confused]" src="confused.gif" />

[Fossil]

as long as you can login as root to the mysql admin<br />type mysql -p<br />(i think <img border="0" title="" alt="[Smile]" src="smile.gif" /> , its been a while)<br /><br />then you must login with the mysql info<br />once there you can make databases, make new users, make tables, etc.<br />check out the mysql manual at <a href="http://www.mysql.com" target="_blank">www.mysql.com</a> - its a good resource<br /><br /><a href="http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_DATABASE" target="_blank">http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#CREATE_DATABASE</a> is for creating databases<br /><br />just follow the syntax there <img border="0" title="" alt="[Smile]" src="smile.gif" />

[likewhoa - Dennis]

/usr/local/mysql/bin/mysql -u root -p<br />create database dbthatyouwannahave;<br />GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON dbthatyouwannahave.* TO username@localhost IDENTIFIED BY 'passwordthatyouwant'; <img border="0" alt="[Ouch]" title="" src="graemlins/ouch.gif" />