debian下安裝mysql,debian安裝mysql

來源:互聯網
上載者:User

debian下安裝mysql,debian安裝mysql

apt-get install mysql-client mysql-server 

中間會要你設定密碼,設定後後就自動啟動mysql了

可以用ps -ef|grep mysql 這樣可以查看到相關的mysql進程

然後修改mysql的的資料庫路徑

1、首先將mysql關掉 service mysql stop

2、然後 /etc/mysql/my.cnf 修改裡面的basedir=/rzcm/mysql/data/mysql

3、將 /var/lib/mysql 帶許可權的複製到 /rzcm/mysql/data  命令為:cp -arp /var/lib/mysql /rzcm/mysql/data

4、啟動服務:service mysql start

如果要用外網ip地址來串連mysql 要到mysql資料的user表裡面

update user set host='%' where Host='localhost'

修改之後重啟mysql 或者flush privileges 即可


相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.