October 4th, 2000, 02:33 PM
I need help with mySQL
I just had my web host install the mySQL on the server I am planning to use.
How do I create a new database and assign user name and password for it?
This is what I do:
./mysql -u root -p
Then enter password. Good, I am logged in
Then when I do this:
CREATE DATABASE somename;
It says that database is created. I guess it's good. But how do assign a user name and password who can use it. I don't want to use root user for it.
Does the user have to be added to the Linux users first or can user be added just to mySQL?
I know that it's possible to add database and users and password in one shot using mysqladmin, but I don't know how to do this.
Reading online help from mySQL.com has been the most frastrating experience I've had in years.
October 4th, 2000, 07:24 PM