I am totally at a dead-end on this... HELP please.
I have spent a week trying to resolve this, searching without success :(
I have checked the manual, archive lists, posted to numerous lists
(with little response), uninstalled, re-installed mysql multiple times.
On my Mandrake-Linux 8.0-Freq2 server, I have these installed...
MySQL-shared-3.23.36-2mdk
MySQL-client-3.23.36-2mdk
MySQL-3.23.36-2mdk
perl-Mysql-1.22_15-5mdk
php-mysql-4.0.4pl1-6mdk
I have no problem with 'mysql -u root -p' from command line.
I can also use 'mysqladmin version', and success using
'telnet localhost 3306' and 'telnet mysite.ca 3306' (mysite.ca is for example)
I have problems with using phpMyAdmin from my server domain.
Problems also happening with log rotation, WebMin, and phpWeblog.
This used to work with MySQL 3.23.31 before the OS upgrade.
----------------
Warning: MySQL Connection Failed: Access denied for user: 'mysite@localhost'
(Using password: NO) in /home/mysite/public_html/phpMyAdmin/lib.inc.php3 on line
170
----------------
I have added users apache and mysite to /etc/group for group mysql, restarted
Apache and mysql. Why is saying 'mysite@localhost' when the script is set to
use mysql user 'dbuser' with valid password. Logging in as 'mysite', and
trying 'mysql -u dbuser -p mysql' works.
>From another site at work, 'mysql -u dbuser -h mysite.ca -p mysql' works.
~mysql is in /var/lib/mysql, data is in /var/lib/mysql/data
/etc/rc.d/init.d # diff mysql mysql~
24c24
< datadir=/var/lib/mysql/data
---
> datadir=/var/lib/mysql
There is no /etc/my.cnf, the /var/lib/mysql/my.cnf contains (partial)
[client]
port = 3306
socket = /var/lib/mysql/mysql.sock
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
tmpdir = /var/lib/mysql/tmp/
skip-locking
set-variable = key_buffer=32M
set-variable = max_allowed_packet=1M
set-variable = table_cache=64
set-variable = sort_buffer=512K
set-variable = net_buffer_length=8K
set-variable = myisam_sort_buffer_size=8M
log-bin
server-id = 1
/var/lib/mysql # ls -lFR
.:
total 37
drwx------ 7 mysql root 544 Aug 17 01:35 data/
-rw-rw---- 1 mysql mysql 116 Aug 16 22:48 log-update.001
-rw------- 1 mysql root 1946 Aug 15 14:52 my.cnf
srwxrwxrwx 1 mysql mysql 0 Aug 17 01:35 mysql.sock=
-rw------- 1 mysql root 0 Aug 16 23:24 mysqld.log
drwx------ 2 mysql root 48 Aug 16 22:10 tmp/
./data:
total 56
drwx------ 2 mysql root 528 Aug 15 12:43 mysql/
drwx------ 2 mysql root 48 Aug 16 22:20 test/
-rw-rw---- 1 mysql mysql 165 Aug 16 23:01 www-bin.001
-rw-rw---- 1 mysql mysql 112 Aug 17 01:35 www-bin.index
-rw------- 1 mysql root 9330 Aug 17 01:35 www.mysite.ca.err
-rw-rw---- 1 mysql mysql 5 Aug 17 01:35 www.mysite.ca.pid
./data/mysql:
total 112
-rw------- 1 mysql root 0 Apr 26 12:06 columns_priv.MYD
-rw------- 1 mysql root 1024 Apr 26 12:06 columns_priv.MYI
-rw------- 1 mysql root 8778 Apr 26 12:06 columns_priv.frm
-rw------- 1 mysql root 1510 Aug 15 14:42 db.MYD
-rw------- 1 mysql root 3072 Aug 15 14:53 db.MYI
-rw------- 1 mysql root 8982 Apr 26 12:06 db.frm
-rw------- 1 mysql root 0 Apr 26 12:06 func.MYD
-rw------- 1 mysql root 1024 Apr 26 12:06 func.MYI
-rw------- 1 mysql root 8641 Apr 26 12:06 func.frm
-rw------- 1 mysql root 135 Aug 14 08:57 host.MYD
-rw------- 1 mysql root 2048 Aug 14 12:49 host.MYI
-rw------- 1 mysql root 8958 Apr 26 12:06 host.frm
-rw------- 1 mysql root 570 Aug 15 14:21 tables_priv.MYD
-rw------- 1 mysql root 3072 Aug 15 14:53 tables_priv.MYI
-rw------- 1 mysql root 8877 Apr 26 12:06 tables_priv.frm
-rw------- 1 mysql root 749 Aug 15 14:42 user.MYD
-rw------- 1 mysql root 2048 Aug 15 14:53 user.MYI
-rw------- 1 mysql root 9148 Aug 15 12:43 user.frm
./data/test:
total 0
Thanks...Dan.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
