[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