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"
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