Connecting to Plesk Mysql though Command Line:
Connection to plesk mysql on ubuntu systems doesn't work in the usual way. Plesk mysql password is stored in a different location and its encrypted too. So we can't keyin the normal password through commandline unless you know the complete encrypted form.So, mysql -u root -p command is not going to work for you. Use the below command to connect to plesk mysql on ubuntu systems through command line. /etc/psa/.psa.shadow ( this is the place where your plesk mysql password is stored ). Use "cat" command to print the password right after -p.
Connection to plesk mysql on ubuntu systems doesn't work in the usual way. Plesk mysql password is stored in a different location and its encrypted too. So we can't keyin the normal password through commandline unless you know the complete encrypted form.So, mysql -u root -p command is not going to work for you. Use the below command to connect to plesk mysql on ubuntu systems through command line. /etc/psa/.psa.shadow ( this is the place where your plesk mysql password is stored ). Use "cat" command to print the password right after -p.
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
No comments:
Post a Comment