MySQL

Administration First connection as root from localhost mysql -u root Set root password SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpwd’) Now you can connect from localhost using mysql -u root -p For security reason, it is better not to allow connection as root from everywhere. Password are stored and communicated encrypted, however SSH is much more …

Continue reading ‘MySQL’ »