Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about how to change the default path in mysql. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

After installing mysql today, because the imported data file is too large and there is not enough disk space in the default path, we have to mount another disk. Because it is not in the root directory, you need to modify the database datadir to a new directory. After modifying / etc/mysql/my.cnf, you will start again, and you will not be able to start it alive or dead. All kinds of Baidu Google will report all kinds of errors all day long. Some say it is the problem of authority, some say it is the problem of selinux, no matter how to change it, it still won't work. Finally, I saw the following in the answer to a post. I tried to change it, and I felt that I was going to succeed.

After the change, start mysql, still report an error, restart / etc/init.d/apparmor restart still does not work.

Continue to Baidu and see this one below.

My mysql directory is not authorized, and I have to empty the basedir (/ xx/mysql/) directory.

Then re-copy the data file of mysql to the / xx/mysql/ directory, and restart successfully.

If you use mysql-u root-p to connect to mysql and report that / var/run/mysqld/mysqld.sock cannot find it, you need to add to the mysql configuration file

[mysqld]

Socket = / xx/run/mysqld/mysqld.sock

[client]

Socket=/xx/run/mysqld/mysqld.sock

[mysql]

Socket=/xx/run/mysqld/mysqld.sock

If you add all three, only add [mysqld], you will still report an error.

It is so troublesome to change the data file path of mysql. ?

This is how to change the default path in the mysql shared by the editor. If you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.