![]() In this case, if you were restoring a database from your home or from your old server, delete all tables, follow the steps above and restore the database again. All other tables remain with the collation, they were initially created. ![]() Please note that after your change the collation of a database only the new tables will be created with the new collation. For this option to work correctly, it is necessary to configure the SMTP in the tool settings. You can now select a collation from the drop down menu and click on the Go button. Forgot your password Allows recovery of the Scriptcase access password. In this field, it is necessary to inform the user to login to Scriptcase. At the bottom of the page you will see the collation option. After clicking proceed, you will be redirected to the Scriptcase Login page. Click on the Operations tab in the top menu of your phpMyAdminĤ. Select the database you wish to manage from the drop-down menu on the leftģ. Enter your cPanel and click on the phpMyAdmin icon in the Databases box.Ģ. If you dont find the line above, add this snippet: mysqld defaultauthenticationplugin mysqlnativepassword Finally, restart the MySQL service in order to enable the new settings. default-autenticação-plugin mysqlnativepassword. ![]() If you wanna change, just follow this 4 steps:ġ. default-authentication-plugin cachingsha2password. ![]() MySQL used to use Latin1 as the default, but most web hosts use MySQL’s default collation as utf8. If your are experiencing problems with some characters save ate your database after you have restored a database from your notebook or your old host, its always a good practice to check for the collation of your old database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |