#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    The administrator installed mysql on
    /import/misc2/mysql-3.22.22/ in Solaris 2.7, however as a user, I experienced the following problem:
    > {prompt:3} mysql
    > ERROR 1045: Access denied for user: 'glo@localhost' (Using password: NO)
    Then I asked the administrator to run the following command in mysql:
    mysql>GRANT ALL ON *.* TO glo@localhost IDENTIFIED BY "password"
    WITH GRANT OPTION

    However, I experienced the same error message as before. Then the administrator tried to killed the daemon and restart, Finally I ended up with this:
    {prompt:4}mysql
    ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock)
    {prompt:5}/import/misc2/mysql-3.22.22/bin/safe_mysqld
    Starting mysqld daemon with databases from /etc/mysql
    mysqld daemon ended
    ---------
    Please Help. Thanks.

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

    Join Date
    Oct 1999
    Location
    SLC, UT, USA
    Posts
    47
    Rep Power
    15
    Did the administrator shut it down with mysqladmin or did he kill the process?

    If he killed the process then try deleting the /tmp/mysql.sock file if it exists.

    Robman
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    1
    Rep Power
    0
    You also need to make sure that you run the mysql command with a "-p" to prompt for a password. That's what the (Using password: NO) means.

    {prompt}3: mysql -p
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or g.
    Your MySQL connection id is 123 to server version: 3.22.30-log

    Type 'help' for help.

    mysql>
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    8
    Rep Power
    0
    I get the same error if I don't place the ./ in front of the command, so
    mysql -u username -p gives me the error
    ./mysql -u username -p doesn't give me the error
    not sure what's different about this program then any other as to why this happens.

Similar Threads

  1. problem: asp files, from access to mysql
    By karib1 in forum MySQL Help
    Replies: 1
    Last Post: November 26th, 2003, 03:16 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. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 10:05 AM
  4. MySQL on Solaris Spark 8
    By aashu.com in forum MySQL Help
    Replies: 0
    Last Post: July 16th, 2002, 08:51 AM
  5. Replies: 1
    Last Post: May 22nd, 2001, 06:10 AM

IMN logo majestic logo threadwatch logo seochat tools logo