Hi! First of all, I have to remind you that expressions like "who is considering switching back to Debian..." won't help much (won't hurt, either, because we're all grown ups, not kids who's having a fight over who's toy is better) About your little issue - why I can *BET* that you altered (by hand or otherways) /etc/my.cnf and/or the directory /var/lib/mysql ??? I am waiting for confirmation of this and then we'll talk about it... Check out my config: /etc/my.cnf [client] port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] log big-tables log-error local-infile = 1 port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K myisam_sort_buffer_size = 8M server-id = 1 [safe_mysqld] err-log=/var/lib/mysql/mysqld.log [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash local-infile = 1 safe-updates [isamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [myisamchk] key_buffer = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout In order to work, you *HAVE* to be SURE that ALL the files within /var/lib/mysql are owned by mysql:daemon or mysql:root - it's a MUST!!! you can check it with ls -lia /var/lib/mysql and repair it entering the following command: chown -R mysql:daemon /var/lib/mysql Looking for your *PERTINENT* comments... Radu ----- Original Message ----- From: "Mark Seven Smith" <pampaluz@cox.net> To: <suse-linux-e@suse.com> Sent: Tuesday, April 13, 2004 11:19 AM Subject: [SLE] I HAD IT WORKING! MySQL under SuSE 9.0 Woes
With everyone's help, I had MySQL working; I could get into that monitor program, and do things like:
show databases;
show tables;
use <databasename>;
And so on. In other words, It Was Working!
Now however, it will NOT work, AND I cannot make it start! I went into YAST and tried to restart MySQL, but this only gave me an error of "Failed". What good is it, if I have to REMOVE THE WHOLE PROGRAM every time I want to use it? It was working yesterday, and now, today after starting my computer up, it is NOT working! ALSO I can't get phpMyAdmin to work; I tried to install it using YAST as someone said to do, but it didn't put anything into /usr/bin that I could run. I don't understand how it works! I did what it says at the page about phpMyAdmin, but it I get all sorts of errors about not being a server, or something. And Apache? Forget it!
Check this out; this is exactly the routine I have been trying to follow to make this thing work. It did just fine the other day...I went through and tried all the ideas that everyone had given me before:
============================================= markvii@linux:~> mysql -u pampaluz -p Enter password: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/ mysql/mysql.sock' (2) markvii@linux:~> su Password: linux:/home/markvii # mysqld --standalone mysqld: ERROR: unknown variable 'innodb_data_home_dir=/var/lib/mysql/' linux:/home/markvii # /etc/init.d/mysql start Starting service MySQL
failed
linux:/home/markvii # /etc/init.d/mysql restart Restarting service MySQL Shutting down service mysql
done
Starting service MySQL
failed
linux:/home/markvii # rcmysql status Checking for service MySQL: unused linux:/home/markvii # chkconfig -s mysql on linux:/home/markvii # rcmysql status Checking for service MySQL: unused linux:/home/markvii # /etc/init.d/mysql start Starting service MySQL
failed
linux:/home/markvii # chkconfig -l mysql mysql 0:off 1:off 2:on 3:on 4:off 5:on 6:off linux:/home/markvii #
Please, I hope someone will know what to do. I mean, I had it working *once*, then it stopped, and I had to remove EVERYTHING and start over; and then I thought I had it made! It worked; up until yesterday when I was done, and I did "shutdown -h now". Today I brought up the system (actually, just a notebook computer, a Compaq Presario 906US), and MySQL won't work! It won't start, just like before when I couldn't make it work, and had to re-install. Does EVERYONE re-install, every time they want to use it? How do you make a database in a single day and get all the use from it that you need in that one day? This doesn't make sense!
Thanks in advance,
--Mark VII (who is considering switching back to Debian--I had no graphics, no X under Debian because I could not configure my notebook under it; but at least I had a console, and I'll bet I could get MySQL to work there, with "apt-get"!)
-- Check the headers for your unsubscription address For additional commands send e-mail to suse-linux-e-help@suse.com Also check the archives at http://lists.suse.com Please read the FAQs: suse-linux-e-faq@suse.com