linux mysql 'localhost' failed

[craig]

RH 9.0

user mysql
command /usr/sbin/mysqld

mysql is being loaded at boot. the previous is listed when I check
what process are running with < ps -aux >

however:
[craig@localhost mysql]$ ./bin/mysqladmin version
../bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
is telling me that it isn't running ??

[Aggro]

craig wrote:

[craig@localhost mysql]$ ./bin/mysqladmin version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
is telling me that it isn't running ??

I think it is running, but clients try to connect to different socket
file than what the server is using. Either change file for server or
change it for clients. Or something has deleted the socket file. Read
more from:

http://www.mysql.com/doc/en/Can_not_...to_server.html

[Aggro]

craig wrote:

[craig@localhost mysql]$ ./bin/mysqladmin version
./bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
is telling me that it isn't running ??

I think it is running, but clients try to connect to different socket
file than what the server is using. Either change file for server or
change it for clients. Or something has deleted the socket file. Read
more from:

http://www.mysql.com/doc/en/Can_not_...to_server.html

[craig]

I think it is running, but clients try to connect to different socket
file than what the server is using. Either change file for server or
change it for clients. Or something has deleted the socket file. Read
more from:

can you tell me.. is the mysql.sock suppose to me listed in my /tmp
directory? I followed the web source you directed me to. The "t" bit
on this directory has been set so no cron can remove mysql.sock as
suggested in the info related to my problem.

[craig@localhost craig]$ mysqladmin -h `hostname` version
mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.0-alpha
Protocol version 10
Connection localhost.local domain via TCP/IP
TCP port 3306
Uptime: 4 days 1 hour 19 min 47 sec

Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000
Above is the output of one of the suggested commands. It would
appear that I "don't" have a socket connection, but rather a TCP/IP
connection. My understanding is that it should be a sock connection
based on the fact that I'm trying to access mysql server from
the very machine that it is running on.

What should I be trying to do here to get something like
<./bin/mysqladmin create testDB > to work

any suggestions

thank you
craig

[craig]

I think it is running, but clients try to connect to different socket
file than what the server is using. Either change file for server or
change it for clients. Or something has deleted the socket file. Read
more from:

can you tell me.. is the mysql.sock suppose to me listed in my /tmp
directory? I followed the web source you directed me to. The "t" bit
on this directory has been set so no cron can remove mysql.sock as
suggested in the info related to my problem.

[craig@localhost craig]$ mysqladmin -h `hostname` version
mysqladmin Ver 8.40 Distrib 4.1.0-alpha, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.0-alpha
Protocol version 10
Connection localhost.local domain via TCP/IP
TCP port 3306
Uptime: 4 days 1 hour 19 min 47 sec

Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.000
Above is the output of one of the suggested commands. It would
appear that I "don't" have a socket connection, but rather a TCP/IP
connection. My understanding is that it should be a sock connection
based on the fact that I'm trying to access mysql server from
the very machine that it is running on.

What should I be trying to do here to get something like
<./bin/mysqladmin create testDB > to work

any suggestions

thank you
craig

[Aggro]

craig wrote:

can you tell me.. is the mysql.sock suppose to me listed in my /tmp
directory? I followed the web source you directed me to. The "t" bit
on this directory has been set so no cron can remove mysql.sock as
suggested in the info related to my problem.

I have the socket file in:
/var/lib/mysql/mysql.sock

And I have this information in file:
/etc/mysql/my.cnf

( Some rows cutted off here )

# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /var/lib/mysql/mysql.sock

( Some rows cutted off here )

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/lib/mysql/mysql.sock
port = 3306

( Some rows cutted off here )

You could check the my.cnf file (If you have it) to see that mysqld and
client are both pointing to the same socket file. And then you could try
to search for the socket file to see where it actually is.

[Aggro]

craig wrote:

can you tell me.. is the mysql.sock suppose to me listed in my /tmp
directory? I followed the web source you directed me to. The "t" bit
on this directory has been set so no cron can remove mysql.sock as
suggested in the info related to my problem.

I have the socket file in:
/var/lib/mysql/mysql.sock

And I have this information in file:
/etc/mysql/my.cnf

( Some rows cutted off here )

# This will be passed to all mysql clients
[client]
#password = my_password
port = 3306
socket = /var/lib/mysql/mysql.sock

( Some rows cutted off here )

[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/lib/mysql/mysql.sock
port = 3306

( Some rows cutted off here )

You could check the my.cnf file (If you have it) to see that mysqld and
client are both pointing to the same socket file. And then you could try
to search for the socket file to see where it actually is.

[craig]

Made some head way since my last message. I couldn't find a my.cnf
on my system. I did find my.large.cnf. I copied it to my /etc based
on the info I read at the mysql web site. I assumed that mysql.sock
would show up in my /tmp if at boot when the server is loaded
could indeed find a my.cnf. Oh and I renamed my.large.cnf to plain
my.cnf. I could have been my.big.cnf; their were two on my system
with by these names.

When I rebooted the sytem I found a mysql.sock in my /home/craig/tmp
directory.

When I tried to /usr/local/mysql/bin/mysqladmin create testDB I now
get:
[craig@localhost mysql]$ ./bin/mysqladmin create testDB
../bin/mysqladmin: CREATE DATABASE failed; error: 'Access denied
for user: '@localhost' to database 'testDB''

So I guess I now have to figure out I guess how I get access for
localhost?

thanks for opening some doors on this issue. Are you fmailiar with
how to assign access to a user?

This has been one long winding road. It's been a month yes a month
of loading various version of mysql and removing just to get
to this point. Maybe that is at the crux of my problems. Whatever
it has been a long ride getting to a point beyond initial
installation of mysql

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_pac ket = 1M
table_cache = 256
sort_buffer_siz e = 1M
read_buffer_siz e = 1M
myisam_sort_buf fer_size = 64M
thread_cache = 8
query_cache_siz e= 16M
# Try number of CPU's*2 for thread_concurre ncy
thread_concurre ncy = 8

the contents of my /etc/my.cnf
I have 512 meg bytes on this system which this cnf was said to be
suited for. Can you suggest which items to reduce it by. I don't
like maxing out my system with just this one server.

[craig]

Made some head way since my last message. I couldn't find a my.cnf
on my system. I did find my.large.cnf. I copied it to my /etc based
on the info I read at the mysql web site. I assumed that mysql.sock
would show up in my /tmp if at boot when the server is loaded
could indeed find a my.cnf. Oh and I renamed my.large.cnf to plain
my.cnf. I could have been my.big.cnf; their were two on my system
with by these names.

When I rebooted the sytem I found a mysql.sock in my /home/craig/tmp
directory.

When I tried to /usr/local/mysql/bin/mysqladmin create testDB I now
get:
[craig@localhost mysql]$ ./bin/mysqladmin create testDB
../bin/mysqladmin: CREATE DATABASE failed; error: 'Access denied
for user: '@localhost' to database 'testDB''

So I guess I now have to figure out I guess how I get access for
localhost?

thanks for opening some doors on this issue. Are you fmailiar with
how to assign access to a user?

This has been one long winding road. It's been a month yes a month
of loading various version of mysql and removing just to get
to this point. Maybe that is at the crux of my problems. Whatever
it has been a long ride getting to a point beyond initial
installation of mysql

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_pac ket = 1M
table_cache = 256
sort_buffer_siz e = 1M
read_buffer_siz e = 1M
myisam_sort_buf fer_size = 64M
thread_cache = 8
query_cache_siz e= 16M
# Try number of CPU's*2 for thread_concurre ncy
thread_concurre ncy = 8

the contents of my /etc/my.cnf
I have 512 meg bytes on this system which this cnf was said to be
suited for. Can you suggest which items to reduce it by. I don't
like maxing out my system with just this one server.

[Aggro]

craig wrote:

So I guess I now have to figure out I guess how I get access for
localhost?

Does it work if you write

mysql -u root

Because you shouldn't have any root password for mysql as default. You
can also try giving -u root parameter for mysqladmin if you prefer using
that. I suggest you to get familiar with mysql console client, because
it is very usefull tool.