RE: MySQL only listens on localhost
Thanks to all: > Check for bind-address in your my.cnf file That solved the problem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL only listens on localhost
Hello, Can anyone please give me a hint what I can do that MySQL also listens to the physical address of the host. I see that MySQL listen only to 127.0.0.1:3306 and therefore every connection via the physical interface is reset. What can I do? Regards Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GRANT & REVOKE Syntax problem
Hi, I have a perhaps simple problem, but it's a problem for me: I have made the following GRANT statement: mysql> GRANT ALL ON ser.* TO [EMAIL PROTECTED]; Query OK, 0 rows affected (0.01 sec) But when I want to REVOKE the GRANT I get the following syntax error: mysql> REVOKE ALL ON ser.* TO [EMAIL PROTECTED]; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TO [EMAIL PROTECTED]' at line 1 What is wrong in the syntax? I only changed GRANT with REVOKE. I am using mySQL version 4.0.15. Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL installation with SuSE Linux 9.0 and YaST
I am not very experienced with Linux, but SuSE Linux 9.0 and YaST makes it very comfortable for me to install various SW-packages. Therefore I try to install also MySQL with YaST. There are MySQL packages (Version 4.0.15) included in SuSE Linux 9.0 distribution and I try to install the server and the client with YaST. But after installation of these packages with YaST - which is the easy part - one has to configure various parameters for MySQL to work properly e.g. create the database files, define group and user, grant access ... Unfortunately the MySQL-manual (which is a big document) does not give any guidelines for installing with YaST. After several times re- and de-installing mysql and also SuSE-Linux itself I still have troubles to get the server running. Has anyone already done a MySQL-installation with SuSE Linux 9.0 and YaST? Is there any "quick installation guide" for this task? I would be very happy to get some help. Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MySQL installation problem
> From: Chris Elsworth Sent: Saturday, December 06, 2003 5:09 PM > > > The msqld.log file shows: > > 031206 15:05:20 mysqld started > > 031206 15:05:20 Fatal error: Can't open privilege tables: > > Can't find file: './mysql/host.frm' (errno: 13) > > 031206 15:05:20 Aborting > > 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete > > Errno 13 is Permission Denied. Is the mysql daemon running with > sufficient privileges to read the directory and files within it? > All the database files should be owned by the mysql user, and are > generally in the mysql group, mode 660. Check that's the case. All mysql-database files in /var/lib/mysql/mysql/ are owned by user=root and group=root, mode =660. There is no mysql group. I installed as user "root" (using YaST) and created the database-files with mysql_install_db also as user "root". Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL installation problem
Hello, I have made a fresh installation of SuSE Linux 9.0. Now I try to install MySQL, but I cannot start mysqld, it always terminates. These are the two installation commands I used after installing with YaST: LPC:~ # mysql_install_db -> all tables have been created in /var/lib/mysql/mysql/ including host.frm LPC:~ # mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 031206 15:05:20 mysqld ended The msqld.log file shows: 031206 15:05:20 mysqld started 031206 15:05:20 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) 031206 15:05:20 Aborting 031206 15:05:20 /usr/sbin/mysqld: Shutdown Complete What is wrong? What can I do now? Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Where to find MySQL-shared-compat-VERSION.i386.rpm ?
Hello, Please forgive me my newbee-question: Where can I find MySQL-shared-compat-VERSION.i386.rpm ? I have just installed MySQL 4.0 and an application requests libmysqlclient.so.10 Franz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]