I just installed MySQL on my new Laptop and everything worked perfektly, but as soon as I pasted in the old databases from the same version of MySQL it began having problems. I restarted my Laptop an now when I try to fill in my Password the Client closes itself and not even the Workbench is able to connect to it. I also tried reconfiguring but my Installer always marks my password as false. As soon as I uninstall and reinstall everything works fine until I restart the Server or my Laptop.

I tried reseting my password but it didnt change anything.

CodePudding user response：

You cannot connect to your MySQL for some reason, which seems to be related to your user credentials. You will need to uninstall MySQL first, reinstall it and make sure everything works even after restarting your server. Do not do anything else at this point. This will be the very first checkpoint, which will confirm that you are successfully installing MySQL and connecting to it.

Now, you will need to carefully study the scripts/installers you want to execute and find specifically the parts that are doing user access, user privilege or other changes. Make sure that you understand what your new user credentials will be, save those values for yourself, update any connections, including Workbench accordingly.

Finally, look at how your programs are trying to connect to MySQL and see whether there is anything incorrect. Of course, during the process, you can always create hy-privileged users.

CodePudding user response：

I solved my problem. I just imported all the stuff like before and before restarting the server i changed the root password in the MySQL Workbench and now everything works fine.