![]() ![]() It is just including all the files in those directories. Those are the locations of your actual configuration fiile. If you open the file and see something like: !includedir /etc/mysql/conf.d/ To find the location of your config file(s) you may run a mysqladmin -help - This should give you something like: $ mysqladmin -helpĭefault options are read from the following files in the given order: Then we remove the skip-grant-tables from my.cnf after we've changed the password and restart mysql to require valid credentials. The point is to add skip-grant-tables to the end of the my.cnf file - Which pretty much makes MySQL not need a login at all to function, thus allowing us to change the password for root. But you can use NANO or whatever editor you feel comfortable using. I would never recommend skipping grant on a production machine with sensitive data stored. I am only answering this OP, because it's a dev machine. ![]() You need to do the following steps to "secure" your setup. But root is empty so it will always fail. Now that you are here and able to TRY to log in. PS: This is for a dev station, it is not for production Thanks to Zak, I can now run the command (I chmod the folder permission to my user instead of mysql) is created with an empty password ! Please consider switching off the -initialize-insecure option.ĮRROR 1698 (28000): Access denied for user what I understand root should work here. What should I do to make an initialize insecure ? I tried setting the log to mysql:mysql with an empty /var/lib/mysql/ but it does not seems to work You can remove all files that the server added to it. T17:35:25.059949Z 0 The designated data directory /var/lib/mysql/ is unusable. T17:35:25.059914Z 0 Could not open file '/var/log/mysql/error.log' for error logging: Permission denied Mysqld: Can't create directory '/var/lib/mysql/' (OS errno 17 - File exists) I want to initialize insecure mysql, but even with a fresh install It does not work : mysqld -initialize-insecure ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |