I just installed Percona Server 5.6 on Ubuntu 14.04 LTS ( standard binary distribution)… I am trying to connect to the server from different host
I am going to grant privileges to ‘root’ accessing db from remote host:
echo "GRANT ALL ON . TO root@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION; FLUSH PRIVILEGES;
But where can i find default password for ‘root’?
No password for “root”? I run "GRANT ALL ON . TO root@’% WITH GRANT OPTION; FLUSH PRIVILEGES;
and it worked