Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    110

    Unanswered: Fresh MySQL 4.0 installation with problem

    Hello everybody

    I`ve just installed MySQL 4.0 under Windows XP SP2 as a service (mysqld-max --install). I have this question. How many users are created by default? I mean, that I could connect to the database with any user. Statements like this connect successfully:

    mysql -u test1 : connects
    mysql -u test2 : connects

    However, I would like to have only two users, root and user1.

    These users should have full privileges on a database e.t.c. database1

    I tried executing these statements :

    CREATE DATABASE bio_tech;
    USE bio_tech;
    GRANT ALL PRIVILEGES ON *.* TO 'root' IDENTIFIED BY 'somepass';
    GRANT ALL PRIVILEGES ON *.* TO 'divined' IDENTIFIED BY 'anotherpass';

    yet I can still connect to MySQL using any user. Furthermore, I can still connect using user root & divined with no password!

    What`s the catch here?

    George Papadopoulos
    Last edited by divined; 11-25-04 at 07:18.

  2. #2
    Join Date
    Apr 2004
    Posts
    110
    I finally managed to change the root password using the statement :

    SET PASSWORD FOR 'root' = PASSWORD('password');

    I failed abysmally to change user`s divined password in the same manner though? Does changing a user`s password differ from changing root`s?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •