Mysql Server安装教程

Mac安装Mysql

1.安装Mysql

2.配置环境变量

打开终端输入：

sudo vi ~/.bash_profile

复制如下内容

# mysql
alias mysql=’/usr/local/mysql/bin/mysql’
alias mysqladmin=’/usr/local/mysql/bin/mysqladmin’

Ubuntu 安装 Mysql

1.使用root账号

sudo apt-get install mysql-server
sudo apt-get install mysql-client
sudo apt-get install libmysqlclient-dev

如果中途有问题就执行以下 sudo apt-get update

2.以上3个软件包安装完成后，使用如下命令查询是否安装成功：

sudo netstat -tap | grep mysql

3.重启MysqlvcD4NCjxibG9ja3F1b3RlPg0KCTxwPi9ldGMvaW5pdC5kL215c3FsIHJlc3RhcnQ8L3A+DQo8L2Jsb2NrcXVvdGU+DQo8aDI+yejWw015U3Fs1LazzLfDzso8L2gyPg0KPHA+MS6x4LytbXlzcWzF5NbDzsS8/qOssNHG5NbQYmluZC1hZGRyZXNzID0gMTI3LjAuMC4x16LKzcHLPC9wPg0KPGJsb2NrcXVvdGU+DQoJPHA+dmkgL2V0Yy9teXNxbC9teS5jbmY8L3A+DQo8L2Jsb2NrcXVvdGU+DQo8cD4yLsq508Nyb290vfjI6215c3Fsw/zB7tDQo6zWtNDQyOfPwjK49sP8we6jrMq+wP3W0G15c3FstcRyb2901cu6xcPcwuujunJvb3Q8L3A+DQo8YmxvY2txdW90ZT4NCgk8cD5HUkFOVCBBTEwgUFJJVklMRUdFUyBPTiA8ZW0+LjwvZW0+IFRPICZsc3F1bztyb290JnJzcXVvO0AmcnNxdW87JSZyc3F1bzsgSURFTlRJRklFRCBCWSAmbHNxdW87cm9vdCZyc3F1bzsgV0lUSCBHUkFOVCBPUFRJT047PC9wPg0KPC9ibG9ja3F1b3RlPg0KPHA+IyC12tK7uPZyb290tcTTw7unw/uju7Xatv649nJvb3TKx8Pcwus8YnIgLz4NCiMgKi4qo7q12tK7uPYqtPqx7cr9vt2/4sP7o7u12rb+uPYqtPqx7bHtw/uho9XiwO+1xNLiy7zKx8v509DK/b7dv+LA77XEy/nT0LHttrzK2siouPjTw7unoaNyb290o7rK2tPocm9vdNXLusWhoyZsZHF1bzslJnJkcXVvO6O6se3KvsrayKi1xNPDu6dJUL/J0tTWuLaoo6zV4sDvtPqx7cjO0uK1xElQtdjWt7a8xNy3w87KTXlTUUzK/b7dv+KhozwvcD4NCjxibG9ja3F1b3RlPg0KCTxwPkZMVVNIIFBSSVZJTEVHRVMgOzwvcD4NCjwvYmxvY2txdW90ZT4NCjxwPiMgy6LQwsioz948L3A+DQo8cD48aW1nIGFsdD0="这里写图片描述" src="/uploadfile/Collfiles/20171115/2017111510451857.png" title="\" />

远程连接

MySQL 连接远程数据库（192.168.1.107），端口“3306”，用户名为“root”，密码“root”

mysql -h 192.168.1.107 -P 3306 -uroot -proot