Here's my response to the items you requested.
Roxanne Sandesara wrote:
OK. Looks like you've got an issue with your MySQL database system.
What, specifically, I can't be sure. First up, I would think, would be
to check the log for the mysql service. See if the service is actually
still running. Check permissions to the data directory to make sure
the unprivileged mysql user has the right to view the data for the
table in question. Then I'd log in, either CLI (command line
interface) or using a MySQL client app if you have one, and see if
that table exists, and what its contents are.
Give you say this happened 'all of a sudden' without you having done
anything you can think of to set this off, it would likely be a good
idea to check for rootkit as well, just in case.
a) ps aux | grep mysql
root 3151 0.0 0.1 4500 1188 ? S 12:20 0:00 /bin/sh
/usr/bin/mysqld_safe --defaults-file=/etc/my.cnf
--pid-file=/var/run/mysqld/mysqld.pid --log-error=/var/log/mysqld.log
mysql 3187 0.0 1.8 137884 18528 ? Sl 12:20 0:00
/usr/libexec/mysqld --defaults-file=/etc/my.cnf --basedir=/usr
--datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking
--socket=/var/lib/mysql/mysql.sock
b) ls /var/log/mysql*
# ls /var/log/mysql*
/var/log/mysqld.log
I did not find any errors or unusual info from this log.
c) ls -al /var/lib/mysql/data
# ls -al /var/lib/mysql/data
ls: /var/lib/mysql/data: No such file or directory
d) mysql -u <username> -p
1) SHOW TABLES;
I don't have a clue on what user should I use with this but probably the
default are being used which I'm not aware off.
Can you please tell me how to check this last info?
---------------------------------------------------------------------
QmailToaster hosted by: VR Hosted <http://www.vr.org>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
