Prob seting up

[tbarlow]

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

[Xnuiem]

have you checked the system error log? or the mysql error log?

[tbarlow]

Originally Posted by Xnuiem

have you checked the system error log? or the mysql error log?

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

[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 ''@'localhost' 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

mysql@enterprise:/etc/rc.d$ /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'
mysql@enterprise:/etc/rc.d$


Can anyone help with this prob

tbarlow

[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

[Xnuiem]

you dont need to type the path, /usr/bin will always be in your path.

your best bet, is to install phpmyadmin...it makes life so much easier.

Dont specify host if it is localhost, that will often confuse mysql.

what command were you using to create the database that returned that error?

[Xnuiem]

the two threads running isnt an issue, it is normal.

From the copy and paste, your first command worked. In UNIX no news is good news.

again, no need to type the path.

I am going to merge your threads.