Hmmmm I wouldn't use that my-huge.cnf file unless that machine is a dedicated mysql server with plenty of ram and even then I wouldn't use it without modification.
Are you sure you have the password correct? A % under host is a synonym for 'any host'. Regards John > Guys, > That's a great response. Thanks. > I have copied /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnfto > /etc/my.cnf and restarted. > However I can no longer log on via the command line from the database box, > > I can still log via a remote client > So I presume the problem is related to the host in the mysql.user table. > mysql -h localhost -u martin -p > Enter password: > ERROR 1045 (28000): Access denied for user 'martin'@'localhost' (using > password: YES) > > mysql> select host from mysql.user where user = 'martin'; > +------+ > | host | > +------+ > | % | > +------+ > > mysql> select host from mysql.user where user = 'root'; > +-----------+ > | host | > +-----------+ > | % | > | 127.0.0.1 | > | localhost | > | object01 | > +-----------+ > > > Sydney Puente schrieb: > >> Hello, >> I want to log all sql queries made against a mysql db. >> Googled and found I should add a line to my.cnf. >> >> However I cannot find a my.cnf file >> [r...@radium init.d]# ps -ef | grep mysql >> root 13614 1 0 Sep24 ? 00:00:00 /bin/sh >> /usr/bin/mysqld_safe --datadir=/var/lib/mysql >> --pid-file=/var/lib/mysql/object01.pid >> mysql 13669 13614 0 Sep24 ? 00:21:40 /usr/sbin/mysqld >> --basedir=/ --datadir=/var/lib/mysql --user=mysql >> --log-error=/var/lib/mysql/object01.err >> --pid-file=/var/lib/mysql/object01.pid >> root 23050 22746 0 19:05 pts/0 00:00:00 grep mysql >> [r...@radium init.d]# locate cnf >> /usr/share/doc/MySQL-server-community-5.1.39/my-huge.cnf >> /usr/share/doc/MySQL-server-community-5.1.39/my-innodb-heavy-4G.cnf >> /usr/share/doc/MySQL-server-community-5.1.39/my-large.cnf >> /usr/share/doc/MySQL-server-community-5.1.39/my-medium.cnf >> /usr/share/doc/MySQL-server-community-5.1.39/my-small.cnf >> /usr/share/man/man8/cnfsheadconf.8.gz >> /usr/share/man/man8/cnfsstat.8.gz >> /usr/share/ssl/openssl.cnf >> /usr/share/mysql/my-large.cnf >> /usr/share/mysql/my-huge.cnf >> /usr/share/mysql/my-innodb-heavy-4G.cnf >> /usr/share/mysql/my-medium.cnf >> /usr/share/mysql/my-small.cnf >> Any ideas? >> I might add i did not install mysql and I did not start it and the guy >> who did is in holiday! >> > > Systemwide config files are always in /etc/ (see: man hier). > > re, > wh > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=john.dais...@butterflysystems.co.uk > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
