[NTLUG:Discuss] Still NO Mysql - Is there at least a MySQL Mailing list?

terry trryhend at gmail.com
Wed Feb 25 23:58:49 CST 2009


This might give you a clue,  (notes from a debian user's mysql install):

=======================================================

In order to install MySQL, we run

apt-get install mysql-server mysql-client libmysqlclient15-dev

You will be asked to provide a password for the MySQL root user - this
password is valid for the user root at localhost as well as
root at server1.example.com, so we don't have to specify a MySQL root password
manually later on:

New password for the MySQL "root" user: <-- yourrootsqlpassword
Repeat password for the MySQL "root" user: <-- yourrootsqlpassword

We want MySQL to listen on all interfaces, not just localhost, therefore we
edit /etc/mysql/my.cnf and comment out the line bind-address = 127.0.0.1:

vi /etc/mysql/my.cnf

[...]
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
[...]

  Then we restart MySQL:

/etc/init.d/mysql restart

Now check that networking is enabled. Run

netstat -tap | grep mysql

The output should look like this:

server1:~# netstat -tap | grep mysql
tcp        0      0 *:mysql                 *:*
LISTEN      6612/mysqld
server1:~#


More information about the Discuss mailing list