1. No Profile Picture
    Devshed Newbie (0 - 499 posts)
    on my local server, i can run mysql with any name, such as:
    mysql -u 123;
    mysql -u ppp;......

    i can use anyone to replace "123" or "ppp", but I could not use root to repalce "123" or "ppp", cause i set password for root.
    so boloney!
    hope I can get help, thank in advance
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2000
    Aalborg, Denmark
    Rep Power

    Are you only able to connect to MySQL or are you also able to access data when you're connected (select, update, etc)

    If you are able to retrieve data you can try to use the REVOKE command to change that.(http://www.mysql.com/Manual/manual.html#GRANT)

    If you want to connect as root when you've set the password use:
    mysql -u root -p
    then you type in your password and you're up and running

    Hope this helps you.

    // Martin

Similar Threads

  1. can't connect to mysql server
    By tentonipete in forum MySQL Help
    Replies: 3
    Last Post: October 6th, 2003, 02:42 AM
  2. Can't connect to MySQL server remotely
    By bper in forum MySQL Help
    Replies: 2
    Last Post: October 2nd, 2003, 02:09 PM
  3. Replies: 6
    Last Post: January 29th, 2003, 12:34 PM
  4. Replies: 2
    Last Post: December 28th, 2002, 12:55 AM
  5. Replies: 4
    Last Post: August 17th, 2002, 02:42 AM

IMN logo majestic logo threadwatch logo seochat tools logo