I'm trying to figure out this user privileges business.
I have Apahe/PHP/MySql installed in my Win98 machine.
I'm trying to create a database using mysqladmin. But I want to create a database for a specific user. I've already added a user to the mysql->user table. How can I create a database (not named test*) that this user can access? If I do:
c:\mysql\bin> mysqladmin create mydb
I can log into mysql (as root) and access this DB, but if I log in as another user, I cannot access this DB!
Any info will be much appreciated.
I have Apahe/PHP/MySql installed in my Win98 machine.
I'm trying to create a database using mysqladmin. But I want to create a database for a specific user. I've already added a user to the mysql->user table. How can I create a database (not named test*) that this user can access? If I do:
c:\mysql\bin> mysqladmin create mydb
I can log into mysql (as root) and access this DB, but if I log in as another user, I cannot access this DB!
Any info will be much appreciated.