Install mysql In debian and mysql In debian

Install mysql In debian and mysql In debian

Apt-get install mysql-client mysql-server

In the middle, you will need to set the password. After the password is set, mysql will be automatically started.

You can use ps-ef | grep mysql to view related mysql processes.

Then modify the mysql database path.

1. First turn mysql off service mysql stop

2. Modify basedir =/rzcm/mysql/data/mysql in/etc/mysql/my. cnf.

3. Run the command "copy/var/lib/mysql with permission" to/rzcm/mysql/data: cp-arp/var/lib/mysql/rzcm/mysql/data

4. start the service: service mysql start

If you want to use an Internet IP address to connect mysql to the user table of mysql Data

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

After modification, restart mysql or flush privileges.