Starting MySQL

How do you start MySQL server using the default RPM installation. I used Webmin and clicked the start button, but it's not showing up as being running. Any ideas?

start using mysqlid application.you can check whether mysql is running or not using mysql manager.

read the 'Read Me' file which will help you to solve the problem easily.also try to post this question in mysql forum here.

to allow tcp/ip for remote connects
mysql.server start
wherever that binary would be located or

3.)safe_mysqld &

or it might be

safemysqld & yeah the above one

do that at your shell and it should be in your way and will start up in safe mode allowing only local socket connections.

1.)mysql_install_db --if not already

2.)you will also have to have proper permissions on your mysql directories

I found the problem. When I installed the rpm, something is missing or wrong. It gives me the error:

ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

Is there a way to fix this?

1.)mysql_install_db --if not already
2.)you will also have to have proper permissions on your mysql directories ie chmod -R 755 /var/lib/mysql

I tried both of those things, and when I try to create a database "mysql_install_db" it asks for me to make a password, but this is what I get when I try:

error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!


I get pretty much the same "cant find socket" error whenever I try to do anything.

mysqladmin isn't used to start mysql.

to start a default redhat mysql install (you need to be root)
type

/etc/init.d/mysql start

to stop it, type

/etc/init.d/mysql stop

When I do this, i just get another message:

"Starting mysqld daemon with databases from /var/lib/mysql
020412 19:39:40 mysqld ended"

and nothing happends.

Hmm. My guess would be in your thrashing you royally mucked something up.

What distribution are you using? Redhat? You never said. Where did you get the RPMs?

/var/lib/mysql and all directories and files under it have to be owned by the user that MySQL runs as- on RedHat it is "mysql".

You can fix this by typing
chown -R mysql.mysql /var/lib/mysql
as root in the console.

Really, if you used the rpms that came with your distribution (which I've been assuming is redhat) and didn't screw things up, it should start using "/etc/init.d/mysqld start " pretty reliably.

From now on, post any and all MySQL questions to the MySQL forum.

Actually I'm using Mandrake 8.0. I got the rpm's from redhat's site. All of the other ones I got from there worked, but I think that this time, there was some difference. I'm going to run the updater this weekend and see if it will download me the correct rpm's.


P.S. Being a beginner, this is the correct forum, seing that no one answered my question in the mysql forum last time.

Perhaps the reason you didn't get an answer before is because you didn't ask a specific enough question, or give enough information. For instance, you should have said what distribution you were using right off.

BTW- you shouldn't have used redhat RPMs with mandrake. That was a no-no.

Why didn't you just use the MySQL packages that came with mandrake? They work fine.

Make sure you read the man page for "rpm" and --erase the rpms before you try and install the correct Mandrake ones, otherwise you're going to be in a world of hurt even more than you are now.

The reason RPM-based systems break (and the reason folks curse them) is when you go around them without fully understand the consequences. . .like this case. Just stick to mandrake rpms in the future and all will work out.

Good luck! Once you get it working, it'll work forever.