Email address obfuscation in effect -- please
click here to turn it off.
[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
On Mon, 2005-05-09 at 17:25 -0500, Mike Miller wrote:
> I just started trying to use mysql. I had no idea that it was so complex
> for a single user. I guess you have to have mysqld running, and root has
> to start mysqld. It also looks like root has to configure mysql user
> accounts with permissions for various databases. It seems that a user
> can't just create his own database and control access rights. Is that
> correct? I hope I'm missing something.
>
> Mike
No, when you set yourself up as a user with GRANT use GRANT ALL
PRIVILEGES on *.* to <name> IDENTIFIED BY 'password';
The user can then create databases. Just login with mysql -p and type
create database <name>;
At lease this works for me. phpmyadmin is sure a nice tool to check what
you have done and to do things when you are feeling lazy.
Steven G. Price
_______________________________________________
members mailing list
EMAIL:PROTECTED
http://mlug.missouri.edu/mailman/listinfo/members
Home | FAQ | Server | Presentations | Mailing Lists/Archives | Member Tools | Links | Sponsors | Contact