where has mysql gone ?

[thecooptoo]

where do i get /var/run/mysqld/mysqld.sock from
router mysql # mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
router mysql # /etc/init.d/mysql status
* status: started
router mysql # ps -A |grep mysql
router mysql # netstat -an | grep 3306
router mysql # lsof -i :mysql | grep LISTEN
router mysql # lsof /var/run/mysqld/mysqld.sock
lsof: status error on /var/run/mysqld/mysqld.sock: No such file or directory
router run # pwd
/var/run
router run # ls -l |grep my
drwxr-xr-x 2 mysql mysql 4096 Dec 17 23:57 mysqld
router mysqld # pwd
/var/run/mysqld
router mysqld # ls -l
total 0
router mysqld #
router files # find / -name *sock
/var/run/cgisock
/usr/portage/net-misc/sock

[Oopsz]

sounds like it didn't start up. /etc/init.d/mysql zap && /etc/init.d/mysql start, and then ps aux|grep mysql. if its not running, then there's something in the config that's keeping it from launching.
_________________
Pop-before-SMTP with the Gentoo Virtual Mailhosting Guide

[thecooptoo]

router files # /etc/init.d/mysql zap && /etc/init.d/mysql start
* Manually resetting mysql to stopped state.
* Starting mysqld... [ ok ]
router files # ps aux|grep mysql
root 19549 0.0 0.2 1372 456 pts/0 S 00:30 0:00 grep mysql
router files # mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
router files #

[tomk]

Is there anything in the logs? Have a look at /var/log/mysql/mysql.err
_________________
Search | Read | Answer | Report | Strip

[Oopsz]

that definitely means that mysql is not loading.
_________________
Pop-before-SMTP with the Gentoo Virtual Mailhosting Guide

[thecooptoo]

router root # /etc/init.d/status
-bash: /etc/init.d/status: No such file or directory
router root # /etc/init.d/mysql status
* status: started
router root # mysql -u root -p
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
router root #


would sem to indicate it is - but where is going?
Or why cant i connetc to it?

AFAIK mysqld.sock is created dynamically
when and by what?

[Oopsz]

if it doesn't show up in ps aux, it's not running, despite what the rc script thinks.

1) zap the init script. 2) what's in your my.cnf?
_________________
Pop-before-SMTP with the Gentoo Virtual Mailhosting Guide

[MagicMonkey]

It sounds like mysql is starting up, but then dying for some reason. Have you only just installed it? My guess is that you haven't created it's initial database (it needs a privs database to start up). There's a script for doing this called something like install-db.sh which needs to be run before mysql will start.

The messages in the error log should give you more of an idea of what's happening; it's probably at /var/log/mysql/mysql.err

[thecooptoo]

having restarted the server ( but ive done that before since having this problem) I can now access the mysql server.
I removed everything from /var/lib/mysql/ & ran mysql_install_db.
It has recreated all the tables in /var/lib/mysql/mysql/
however i cant access anything as root.
router mysql # mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18 to server version: 4.0.14

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use mysql
ERROR 1044: Access denied for user: 'root@' to database 'mysql'
mysql>

when i try to creae a new database using webmin
i get
Failed to create database : DBI connect failed : Access denied for user: 'root@' to database 'mysql'

ie the root user doesnt have permission to access the mysql DB ( which the one that stores privileges (isnt it?)
So how do i get my root user to get access to the mysql DB & tables?

ive tried chowning everything to root and chmodding to 777 , which didnt solve it.

router mysql # cat my.cnf |grep -v '#'
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[safe_mysqld]
err-log = /var/log/mysql/mysql.err
[mysqld]
skip-innodb
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
language = /usr/share/mysql/english
skip-locking
set-variable = key_buffer=16M
set-variable = max_allowed_packet=1M
set-variable = thread_stack=128K
bind-address = 127.0.0.1
port = 3306
[mysqldump]
quick
set-variable = max_allowed_packet=1M
[mysql]
[isamchk]
set-variable = key_buffer=16M
router mysql #

[MagicMonkey]

Try typing the following:

mysql -u root -h localhost mysql

and see what happens. Good luck...

[MagicMonkey]

[thecooptoo]

many thanks :D :D .
Now to try phpwebsite/phpnuke/ etc etc

[eltech]