This is Bavaria, Germany!
home:/# apt-get install mysql-server
Let the database server listen to network. Edit /etc/mysql/my.cnf:
[mysqld] bind-address = 10.95.81.74
You need this if you want to have a special password for user root to make exports or so
# mysql -uroot
use mysql;
update user set password=PASSWORD("newpassword_for_root") where User='root';
flush privileges;
mysql3:/etc# mysql -uroot
mysql> set password for 'root' = password('yyy');
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON *.* TO 'wwwrun' IDENTIFIED BY 'xxx';
Query OK, 0 rows affected (0.00 sec)
mysql> delete from user where host='localhost' and user='';
Query OK, 1 row affected (0.00 sec)
mysql> delete from user where host='mysql3' and user='';
Query OK, 1 row affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit;
Check the accounts from commandline - from outside network:
mysql3:/etc# mysql -uwwwrun -pxxx -hmysql3.rosi13.de Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.49-log
mysql3:/etc# mysql -uroot -pyyy -hmysql3.rosi13.de Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.49-log
Check the accounts from commandline - from inside:
mysql3:/etc# mysql -uwwwrun -pxxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.49-log
mysql3:/etc# mysql -uroot -pyyy Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 to server version: 3.23.49-log