Need help with my sql..

Z28kid · 03-01-2003, 02:22 AM

i can't seem to get it started or even find the directory. when i do a search this is what i get for my sql..

/usr/bin/mysql

/usr/lib/mysql

/usr/include/mysql

I get all these when i do a seach.. What do they mean?

Also how do i get mysql running???

Crashed_Again · 03-01-2003, 02:01 PM

If you have mysql installed correctly you can start it by doing:

/etc/init.d/mysqld start

Remember there is a mysql server and mysql client package.

bulliver · 03-01-2003, 03:44 PM

If you don't have the init script then there is a script that comes with MySQL for starting the server. It should be in /usr/bin according to what you stated above. It's called safe_mysqld and you can run it like this:

/usr/bin/safe_mysqld&

be sure to add the '&' or your console will be tied up.

Z28kid · 03-01-2003, 06:55 PM

i did "/ect/int.d/mysqld start" and it said there was no such file or directory.

Then i did "/usr/bin/safe_mysqld&" and it said [1] 1138 then after that it said "bash: /usr/bin/safe_mysqld:" no file or directory

I am totally confused about this. i can't seem to get it started

anymore help please???

Crashed_Again · 03-01-2003, 06:59 PM

It seems as though you don't have MySQL installed. If you are running RedHat 8.0 go to System Settings->Packages . You can install all the necessary packages for MySQL from there.

Z28kid · 03-01-2003, 07:22 PM

i did have it installed but i took it out.

anyway i did "/usr/bin/safe_mysqld&"

This is what i got:

[1]

starting mysqld daemon with databases from /var/lib/mysql

mysqld ended.

is it suppose to end?

Z28kid · 03-01-2003, 07:23 PM

oops i meant to say i took it out but i reinstalled it and i got those things from previous post.

Z28kid · 03-01-2003, 07:26 PM

i just did ps -ax and at the end of it i got:

[1]+ Done /usr/bin/safe_mysqld

then i did ps -ax again and nothing came up.

any help?

sorry for posting so many times but this is getting to me.

bulliver · 03-01-2003, 10:09 PM

This might be becuase the user you are trying to run mysql as is not authorized. Create a user 'mysql' with group 'mysql' and try:
/usr/bin/safe_mysqld --user=mysql&

Z28kid · 03-02-2003, 07:37 PM

how would i give access to this user?