install

mac:brew install mysql ubuntu:sudo apt-get install mysql-server

setup

首先启动mysql:mysql.server start 初始化并设置root密码：mysql_secure_installation

some error

ERROR 1146 (42S02): Table ‘mysql.role_edges’ doesn’t exist:sudo mysql_upgrade -u root -p

allow remote

ubuntu:

1. 编辑/etc/mysql/mysql.conf.d/mysqld.cnf文件，并注释bind-address = 127.0.0.1,
2. 重启mysql：sudo /etc/init.d/mysql restart

--EOF--

若无特别说明，本站文章均为原创，转载请保留链接，谢谢