Hello
I just installed (upgraded) to linux slackware 12.0, and I told mysql to startup on it own dureing startup, and when the system boots U can see it start mysql, but then the very last thing it does is STOP mysql, can someone tell my how to get it to start and stay started thanks.

tbarlow

ya and the weird thing is that in the /var/log dir there is not mysql log file or even in the syslog there is nothing said about mysql it just start and then the next line ends

tbarlow

Well I got it to load at startup but now I have a new prob when I try to add a database I get this error

mysql> CREATE DATABASE eacentral;
ERROR 1044 (42000): Access denied for user [email="''@'localhost'"]''@'localhost'[/email] to database 'eacentral'
mysql>

also when I run this command like it says to do in the install info

/usr/bin/mysqladmin -u root -h enterprise password 'new-password'

I get this error

[email="mysql@enterprise:/etc/rc.d$"]mysql@enterprise:/etc/rc.d$[/email] /usr/bin/mysqladmin -u root -h enterprise password 'temp'
/usr/bin/mysqladmin: connect to server at 'enterprise' failed
error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'
[email="mysql@enterprise:/etc/rc.d$"]mysql@enterprise:/etc/rc.d$[/email]


Can anyone help with this prob

tbarlow

Hello

Well I got it to start and well here is where I am now

mysql@enterprise:~$ /usr/bin/mysqladmin -u root password 'mypwd'
mysql@enterprise:~$ /usr/bin/mysqladmin -u root -h enterprise password 'mypwd'
/usr/bin/mysqladmin: connect to server at 'enterprise' failed
error: 'Host 'enterprise.barlows1.net' is not allowed to connect to this MySQL server'
mysql@enterprise:~$

as U can see I ran the commands it told me to run but it is not working how can I fix this

tbarlow

P.S
should there be 2 mysql things running I did a px -ax and got this

2951 ? S 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mys
2979 ? Sl 0:00 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file

thanks

tbarlow