mysql

problems starting

[yomero]

Hi,
I have a problem, my mysql prog. won't start.
I use mysql.server start and safe_mysqld.

What am i doing wrong?

[sugarkane]

Hi yomero, welcome to wmw

What operating system are you running? What happens when you try and start it - any error messages etc?

[yomero]

I'm using red hat 6.1 and i get this error:
[root@ns share]# mysql.server start
bash: mysql.server: command not found
[root@ns share]# mysql start
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

and

[root@ns mysql]# safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
010917 13:28:04 mysqld ended

[sugarkane]

It's a while since I've used RH6.1, but from memory there's a startup script under /etc/rc.d/init.d/

Try changing to that directory (maybe it's just /etc/init.d/ ? I'm not sure) and running the script with

./mysql start

That **should** work, let us know how you get on...

[yomero]

I get the same error:

[root@ns init.d]# ./mysql start
[root@ns init.d]# Starting mysqld daemon with databases from /var/lib/mysql
010917 15:27:12 mysqld ended

[bartek]

what do you get with
ps -aux ¦ grep mysqld?

[yomero]

[admin@ns admin]$ ps -aux ¦ grep mysqld
ERROR: User name does not exist.

Where/how do i create a user?

[bartek]

Try this link for starters [mysql.com], and go through that site in detail. There are many config options, it's really hard to guess what the problem is...
hth

[yomero]

Hey, i'm back, i have done quit a bit of research but can't solve my problem.
Another thing is that i had postgresql in my server and haven't uninstalled it.
On an error log file i found this:
010915 12:20:33 mysqld started
/usr/sbin/mysqld: ready for connections
A mysqld process already exists at Mon Sep 17 13:23:55 EDT 2001
010917 13:28:04 mysqld started
010917 13:28:04 Can't start server: Bind on TCP/IP port: Address already in use
010917 13:28:04 Do you already have another mysqld server running on port: 3306 ?
010917 13:28:04 Aborting

Does that have to do something with postgresql?

[sugarkane]

Certainly looks like *something* is using the port. Try doing:

cat /etc/services ¦ grep 3306

and see what comes up...

[circuitjump]

I had a similar problem before.

Try starting the mySQL server without the grant tables, like so

% safe_mysqld --skip-grant-tables

Then flush privileges with this command

% mysqladmin flush-privileges

Hopefully that works