![]() ![]() So basically I'm stuck in a loop where it seems that simply uninstalling everything, including removing /etc/mysql folder and all of its content, isn't enough, or is just the wrong way.Ībout system _ĭesktop Enviroment : KDE Plasma Version: 5.24.7 I get the 'ERROR 1290 (HY000): The MySQL server is running with the -skip-grant-tables option so it cannot execute this statement'.īut again, if I remove the '-skip-grant-tables' option, I get the access denied error when trying to access Mysql.Ĭonclusion _ ' ALTER USER IDENTIFIED WITH mysql_native_password BY 'r Now i'm in mysql, but the problem persists: my 'user' table is empty and if I try to In the '/etc/mysql/my.cnf' file, just above the The only way I can log back in is by adding If I try to open the local host on Mysql workbench it just pops out the access denied error again, same with Tableplusįake error fix _ I also tried to add the 'binding-address = 127.0.0.1' in '/etc/mysql/my.cnf' under '' I tried to run it like this too 'mysql -u root -p (using root as passwd)', but ofc it didn't wok O) or ERROR 1045 (28000): Access denied for user (using password: YES) ![]() I couldn't access mysql anymore, not even with the sudo command 'sudo mysql', getting this errorĮRROR 1045 (28000): Access denied for user (using password: N Problems _Īfter every try I restarted the rvice with the command I did a repository update before trying to reinstall 'sudo apt update'Īnd then i went for a fresh install 'sudo apt install mysql-server' I uninstalled everything using 'sudo apt purge mysql*' and 'sudo rm -rf /etc/mysql' I tried to look for a fix online, but at the end i just went for the good old uninstall-reinstall process.Įarly steps _ The thing is that the first time that I installed it was by using the 'sudo apt install mysql-server' and I always ran it from terminal with 'sudo mysql' command. ![]() I've been using Mysql for a couple of months and now i have to connect it to python via the 'pymysql' lib. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |