#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Netherlands
    Posts
    32
    Rep Power
    15
    Hi,

    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[1]['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.

    config.inc.php3:
    $cfgServers[1]['adv_auth'] = false;
    $cfgServers[1]['stduser'] = 'stuser';
    $cfgServers[1]['stdpass'] = 'pw';
    $cfgServers[1]['user'] = '';
    $cfgServers[1]'password'] = '';
    $cfgServers[1]['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?

    Thanks,

    Richie
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    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.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Netherlands
    Posts
    32
    Rep Power
    15
    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?

Similar Threads

  1. Doing More with phpMyAdmin (Part 2)
    By gnorb in forum Development Articles
    Replies: 5
    Last Post: December 23rd, 2004, 10:21 PM
  2. MySql & phpMyAdmin on home WinXP
    By mdhall in forum MySQL Help
    Replies: 2
    Last Post: October 28th, 2003, 03:48 PM
  3. How to Dump SQL data via phpMyAdmin.
    By YCoco in forum MySQL Help
    Replies: 4
    Last Post: February 10th, 2003, 11:57 AM
  4. User access to phpMyAdmin
    By jjanes in forum PHP Development
    Replies: 2
    Last Post: September 19th, 2002, 05:35 PM
  5. PhpMyAdmin 205
    By Richard Vos in forum MySQL Help
    Replies: 1
    Last Post: July 12th, 2000, 10:35 PM

IMN logo majestic logo threadwatch logo seochat tools logo