Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
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
I do this: ./configure --with-prefix=/usr/local/mysql and get this:
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!
Starting the mysqld server. You can test that it is up and running
with the command:
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?!
From /etc/rc.d/rc.mysqld (from Slack 9.1 installation packages):
# Before you can run MySQL, you must have a database. To install an initial
# database, do this as root:
# su - mysql
# 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').
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
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.