"mysqld ended"

flamesrock · 03-04-2004, 08:39 PM

after starting up my slackware system, I get this error at the login prompt:

040304 18:24:05 mysqld ended

After clicking enter, I'm given a login prompt which I can actually login to without recieving this error.

So the mysql daemon was ended. My question is why? And how do I get it to *not* end?

This is off of a clean slackware install, with mysql and all of the necessary libs included, so I have no idea why it would want to end.

YMHiK · 03-04-2004, 11:18 PM

You may want to check your config details in your /etc/my.cnf
Once I got same problem, but I compiled mysql from sources and made clean install... the fix for me was to fix permission to tables(actual phisycal files) and set up corretly my.cnf

ilhbutshm · 03-05-2004, 02:02 AM

I do this: ./configure --with-prefix=/usr/local/mysql and get this:

Quote:

Installing all prepared tables
040304 11:21:09 ./bin/mysqld: Shutdown Complete

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h p166 password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com

Starting the mysqld server. You can test that it is up and running
with the command:
./bin/mysqladmin version
root@p166:/home/supr/sf/mysql-standard-4.0.18-pc-linux-i686# Starting mysqld daemon with databases from /home/supr/sf/mysql-standard-4.0.18-pc-linux-i686/data
040304 11:21:11 mysqld ended

the thing just stops here... what am I doing wrong?!

(fresh slack9.1 install..)

nightwulf · 03-05-2004, 05:37 PM

From /etc/rc.d/rc.mysqld (from Slack 9.1 installation packages):

Quote:

# Before you can run MySQL, you must have a database. To install an initial
# database, do this as root:
#
# su - mysql
# mysql_install_db
#
# Note that step one is becoming the mysql user. It's important to do this
# before making any changes to the database, or mysqld won't be able to write
# to it later (this can be fixed with 'chown -R mysql.mysql /var/lib/mysql').

Tried this?

Regards,
nightwulf

LeniuNYC · 03-05-2004, 05:49 PM

well, i was getting the same thing, it was annoying me for a whle and then i reinstalled slackware without the option ' to start mysqld at startup', and then i added the start at startup myself and everything is fine.
but im sure there's an easier way to do it :P

flamesrock · 03-06-2004, 01:01 AM

Thanks! I got it to work.

But now I'm getting another error. When I try to create a new database::

mysql /var/www/htdocs/score/score.sql

it gives me this::

ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Any ideas?

-Thanks

flamesrock · 03-06-2004, 11:41 AM

Come on people, please

I hate to bump this but I have no clue what to do.

Qzukk · 03-06-2004, 01:04 PM

Check your access settings. Did you set a password for the root@localhost account? (You aren't using a password when you try to connect there) Note that user "root" is different account from "root@localhost", maybe you should try connecting through the socket instead of to localhost via TCP.

If all else fails, there is an entire section on resetting your access table http://www.mysql.com/documentation/m...ng_permissions

flamesrock · 03-06-2004, 01:18 PM

Thankyou! I'm gonna see if I can fix this.

flamesrock · 03-07-2004, 06:17 PM

k, I set the password, but I'm still getting this:

root@localhost:~# mysql /var/www/htdocs/score/score.sql
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
root@localhost:~#
root@localhost:~#
root@localhost:~#

I'm logged in as root@localhost, so shouldn't it not still be giving me this error?

Any help would be greatly appreciated

-Thanks!

flamesrock · 03-07-2004, 10:00 PM

okay, now its saying that it can't find mysql.sock, AND whenver I type:

mysqld_safe &

which should start it, it ends up saying:

root@localhost:~# mysqld_safe &
[1] 1567
root@localhost:~# Starting mysqld daemon with databases from /var/lib/mysql
040307 08:52:29 mysqld ended

[1]+ Done mysqld_safe
root@localhost:~#

What should I do? This is very confusing.

-Thanks