本文介绍了如何在系统中安装MySQL5.0版本，并设置了root用户的密码。此外还讲解了如何检查MySQL服务监听的地址，以及根据不同的监听地址设置相应的安全措施。
Installing MySQL 5.0
First we install MySQL 5.0 like this:
Create a password for the MySQL user root (replace yourrootsqlpassword with the password you want to use):
Then check with
on which addresses MySQL is listening. If the output looks like this:
which means MySQL is listening on localhost.localdomain only, then you’re safe with the password you set before. But if the output looks like this:
you should set a MySQL password for your hostname, too, because otherwise anybody can access your database and modify data:
First we install MySQL 5.0 like this:
sudo apt-get install mysql-server mysql-clientCreate a password for the MySQL user root (replace yourrootsqlpassword with the password you want to use):
sudo mysqladmin -u root password yourrootsqlpasswordThen check with
netstat -tap | grep mysqlon which addresses MySQL is listening. If the output looks like this:
tcp 0 0 localhost.localdo:mysql *:* LISTEN 2713/mysqldwhich means MySQL is listening on localhost.localdomain only, then you’re safe with the password you set before. But if the output looks like this:
tcp 0 0 *:mysql *:* LISTEN 2713/mysqldyou should set a MySQL password for your hostname, too, because otherwise anybody can access your database and modify data:
sudo mysqladmin -h serverip -u root password yourrootsqlpassword
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
