can't connect to mysql

From: Eric Cheney (cheney_at_soc.umass.edu)
Date: 05/15/05

  • Next message: Chris Knipe: "Re: can't connect to mysql" 
    Date: Sun, 15 May 2005 15:37:11 -0400
To: freebsd-questions@freebsd.org

    Hello. I'm trying to get MySQL4.0 working. I've installed it using
    /stand/systinstall (as well as ports method on another attempt).
    I got a report from sysinstall that MySQL was installed. That's
    both the client and the server (it caught the dependencies.)

    But here's the problem: I can't connect to the database.

    Here's the error I get....

    ****begin error message******

    max# mysql -u root -p
    Enter password:
    ERROR 2002: Can't connect to local MySQL server through socket
    '/tmp/mysql.sock' (2)

    ****end error message******

    I did the above leaving the password blank because I haven't set up
    a password for root on MySQL yet.

    Which brings up another problem. I've tried the below and get the
    stated message.....

    ****begin error message******

    max# mysqladmin -u root password 'newpassword'
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket
    '/tmp/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/tmp/mysql.sock'
    exists!
    max#

    ****end error message******

    Well sure enough, /tmp/mysql.sock does not exist. And a "ps waux |
    grep msyql" leaves me to believe that mysql is not running.

    So then I did this, as root ....

    max# /usr/local/etc/rc.d/mysql-server.sh start

    And still mysql is not running, and I get the same problems as
    stated above.

    Any ideas about what I'm doing wrong?

    Thank you. 

    -- 
<Eric Cheney>   cheney@soc.umass.edu        
_______________________________________________
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
  • Next message: Chris Knipe: "Re: can't connect to mysql"

    Relevant Pages

    • [Full-Disclosure] Proofpoint Protection Server remote MySQL root user vulnerability
      ... The MySQL server may be remotely access by the "root" user without using ... The Proofpoint Protection Server is a software product to filter spam ... the embedded MySQL 4.0 server binds to the default port ... Remote root will not be able to FLUSH ...
      (Full-Disclosure)
    • Re: INSTALAÇÃO DEBIAN LAMP!
      ... You should only use english in this list. ... >acessar o MySql e diz que eu não tenho permissão para acesso (isso pq eu ... >estou como ROOT). ... Sin importar el usuario, si quieres entrar a mysql como root, ...
      (Debian-User)
    • Re: Need Help setting up Mysql on Openserver 6.0
      ... >> Essentially the same as included with the SCO Doc server. ... > the Root Password... ... Stopping mysql ... ... SET PASSWORD FOR 'root'@'localhost' = PASSWORD; ...
      (comp.unix.sco.misc)
    • mysql connect problems
      ... starting out with MySQL or MySQL-dependent packages run into this. ... Neither of the two above-mentioned applications can connect to my ... # mysql -u root -p ... mysql database, and run 'select user, password, host from user;' I see ...
      (freebsd-questions)
    • Re: Error 1044 Access denied to database
      ... Or perhaps it is just a bug with php or MySql? ... When you installed MySQL you had a root account at the very beginning. ...
      (alt.php)