admin ques.

cmack · 2002-10-30T00:25:52+00:00

two quick questions. How can I change my Administrative password into MySQL from user ODBC and 'blank' password over to something I can relate to. I tried...

admin ques.

cmack

two quick questions.

How can I change my Administrative password into MySQL from user ODBC and 'blank' password over to something I can relate to. I tried going into the php.ini file and changing it there. No such luck.
If I create a new table within a new database that I have created where does the admin rights come from? I mean can a create a small user table within that new database I just created. Or can I still get in (for testing purposes) via my global password and log-in (ODBC, ' ' , localhost)

Thanks for any help, I've kinda been at it for a while and is stumped.

Cmack

theeper

MySQL has it's own form of user authentication. It uses the tables in the mysql database to maintain user privileges. There are a couple different methods for adding users and specifying privileges. You really need to read this ...

http://www.mysql.com/doc/en/Privileges.html

If you are using MySQL from your ISP and your user does not have permission to GRANT permissions to other users, you may have to have the ISP add your users for you.