July 19th, 2000, 09:34 AM
I still connect as root using my rootpassword. I would like to change this. I do not want to connect as rootuser. So...
As far as I know right now, I should make a standard user and password to connect using $cfgServers['adv_auth'] = true;.
Using phpmyadmin I made a new user 'stuser' with a password and following permissions (Y N N N N N N N N N N N N N --> By the way, is this okay? Or does it make sense to disable select permission?). And gave also select-privelege to this user for the mysql-database (Y N N N N N N N N N N N N N ).
I changed the config.in.php3-file accordingly.
$cfgServers['adv_auth'] = false;
$cfgServers['stduser'] = 'stuser';
$cfgServers['stdpass'] = 'pw';
$cfgServers['user'] = '';
$cfgServers'password'] = '';
$cfgServers['only_db'] = '';
A refresh of the browser shows the auth-popup window, asking for user + password.
But no way I could enter using passwords from the user table (even 'root' + root-password did not work). It says it can't connect to stuser@localhost.
Do you have a clue what is going on?
July 19th, 2000, 10:16 AM
If you change permissions by directly manipulating the mysql.* tables, you will need to do a flush privileges or stop/start mysqld for the permissions tables to be reread.
I would advise against doing direct manipulation. Unless you are using an earlier version of MySQL, just use the GRANT query. With GRANT you are much less likely to mess up your permissions AND you don't have to flush.
July 19th, 2000, 10:36 AM
Thanks for your fast reply, Rod.
I did not understand it all, but I closed mysql and restarted it, that will do some rereading. But still can't get in. It keeps asking me a password when using a user from the user table and password.
Do you mind take a look at the user permissions in the first e-mail?