After Mysql upgrade to 5.6, unable to create new databases

After Mysql upgrade to 5.6, unable to create new databases

webuzo_manager	June 20, 2016, 6:05 am \| Post: 3
Group: Member Post Group: Elite Member Posts: 268 Status:	Hi, If you facing this issue please follow these steps to change your MySQL root password : 1. Firstly Stop MySQL service, use this command and execute it multiple times untill no mysqld process is running : service mysqld stop 2. Start MySQL with option: /usr/local/apps/mysql56/mysqld --skip-grant-tables 3. Login to MySQL as: mysql -u root 4. Change database to mysql as: use mysql; 5. Update root user password as: update user set password=PASSWORD("NEWPASSWORD ") where user='root'; note: NEWPASSWORD should be replaced with desired password, everything else stays the same... 5.5 Flush the privileges using the following command : flush privileges; 6. Exit from mysql, using the command: exit; 7. Stop all MySQL service as (execute it multiple times until no process is present): killall mysqld 8. Start MySQL service normally as: service mysqld restart 9. Check whether new password is working fine by loging in as: mysql -u root -p note: After this MySQL will prompt you for password. Please enter the NEWPASSWORD set by you above. 10. Update /var/webuzo/my.conf with the new working password.
IP: --

Users viewing this topic
	1 guests, 0 users.