Results 1 to 7 of 7

Thread: Mysql problem

  1. #1
    Just burned his ISO bluster's Avatar
    Join Date
    Dec 2007
    Posts
    22

    Default Mysql problem

    Hi everyone. So i got the problem with setting mysql server on bt3. Here is the konsole error output:

    Code:
    bt ~ # mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
    
    bt local # /usr/local/bin/mysqld_safe &
    [2] 3815
    bt local # 080319 17:10:29 mysqld_safe Logging to '/usr/local/var/bt.err'.
    080319 17:10:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
    080319 17:10:29 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
    
    bt ~ # /usr/local/bin/mysql_secure_installation
    
    NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
          SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!
    
    In order to log into MySQL to secure it, we'll need the current
    password for the root user.  If you've just installed MySQL, and
    you haven't set the root password yet, the password will be blank,
    so you should just press enter here.
    
    Enter current password for root (enter for none):
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
    Enter current password for root (enter for none):
    
    bt mysql-test # perl mysql-test-run.pl
    Logging: mysql-test-run.pl
    080319 17:11:04 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
    
    080319 17:11:04 [ERROR] Aborting
    
    mysql-test-run: *** ERROR: Could not find version of MySQL
    Output from error log file:

    Code:
    080317 03:10:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
    /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
    080317  3:10:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    080317  3:10:57 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/bt.pid' (Errcode: 13)
    080317  3:10:57 [ERROR] Can't start server: can't create PID file: Permission denied
    080317 03:10:57 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
    080319 02:50:55 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
    /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
    080319  2:50:55 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    080319  2:50:55 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/bt.pid' (Errcode: 13)
    080319  2:50:55 [ERROR] Can't start server: can't create PID file: Permission denied
    080319 02:50:55 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
    080319 17:10:29 mysqld_safe Starting mysqld daemon with databases from /usr/local/var
    /usr/local/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
    080319 17:10:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    080319 17:10:29 [ERROR] /usr/local/libexec/mysqld: Can't create/write to file '/usr/local/var/bt.pid' (Errcode: 13)
    080319 17:10:29 [ERROR] Can't start server: can't create PID file: Permission denied
    080319 17:10:29 mysqld_safe mysqld from pid file /usr/local/var/bt.pid ended
    Another from konsole:

    Code:
    bt ~ # mysql_upgrade
    Looking for 'mysql' in: /usr/local/bin/mysql
    Looking for 'mysqlcheck' in: /usr/local/bin/mysqlcheck
    Running 'mysqlcheck'...
    /usr/local/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) when trying to connect
    FATAL ERROR: Upgrade failed
    
    
    bt ~ # mysqladmin --socket=/tmp/mysql.sock version
    mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
    Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! ( yeah, it exists ;/ )
    i was trying all stuff from mysql official site, setting chmods, chown, editing socket path in my.cnf and i am outta ideas now how to set it to work
    Can anyone tell me what is wrong with it?
    Btw, i'm totaly new to setting mysql server, never done it before...

  2. #2
    Good friend of the forums
    Join Date
    Feb 2010
    Posts
    328

    Default

    I would assume theres an RC script some place to start mysql idiot proof you just have to find out the password

  3. #3
    Member
    Join Date
    Mar 2008
    Posts
    114

    Default

    Have a look to mysql config file. There is some stuff to change.
    And for connecting to mysql (not starting the process) you have to know the login and password. By default, who can access it with the roo account :

    mysqladmin -u root --password...

  4. #4
    Just burned his ISO bluster's Avatar
    Join Date
    Dec 2007
    Posts
    22

    Default

    Jezzz, my brain is going to blow...I've reinstalled mysql and now there is no mysql.sock file at all ;/ no my.cnf too...And it makes me LOL, when i am trying to find some mysql folders and what? They do not exist too! My first install was mysql 6 alpha and everything was in the place, now i got version 5 and it looks like it is here, but its not abstract application or something xD When i was installing it on debian(from the repositories) there was something like mysql binaries and during instalation i got a dialog window to set root pass, after all, mysql was working perfect. Here on slack i am realy going crazy right now
    Every time i got the same error:
    Code:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    and root pass is empty i think...Gosh, for a couple of month bt is my only OS and i do not want to return to debian

  5. #5

  6. #6
    Just burned his ISO
    Join Date
    Sep 2008
    Posts
    1

    Default

    hmmm...

    got the same probleme here....

  7. #7
    Good friend of the forums
    Join Date
    Feb 2010
    Posts
    328

    Default

    just look for /etc/init.d/mysql* or what ever the path is for slax I think BT3 uses...

Posting Permissions

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