phpmyadmin should use that password so not quite sure what you mean by 'for both'. This is beyond the scope of the question but next I would be looking into hooking the unix user creation process to automatically creating a matching MySQL user account. You can change the mysql root password by logging in to the database directly ( mysql -h yourhost -u root) then run. I also created a MySQL account with the same username as my unix account, again with no password, and using the root account I granted it access to the tables I needed, then I could also connect from apps from my user account without changing to root. Having a strong password is the most important aspect of the security of your account. In the section beginning with the line To test open a new Terminal and do sudo su then mysql and check if it connects with no password (this didn't work when a password was set). To change the password of the root user in Ubuntu, run the following command as a sudo user : sudo passwd root You will be prompted to enter and confirm the new root password. This allows for some greater security and usability in many cases, but it can also complicate things when you need to allow an external program like phpMyAdmin to. Then both MySQL (of xampp and lamp as well) will run. In Ubuntu systems running MySQL 5.7 (and later versions), the root MySQL user is set to authenticate using the authsocket plugin by default rather than with a password. which would be different from that of xampp. You can also open server.xml in your lampp and change the port no. Just put new password or remove it as per your need: / Authentication type /. You need to reconfigure it because lamp and xampp run phpmyadmin in different ports. Just go to Wamp Directory on your window and check phpmyadmin in apps folder inside wamp. I connected as root using the password then ran: run the command: sudo dpkg-reconfigure phpmyadmin. The installation process continues until another configuration screen displays that prompts you to confirm if you want to configure your database for phpMyAdmin by using dbconfig-common. I also created a root password at installation and wanted to change back to using unix authentication once I understood that if I run commands or launch apps as root they can connect to the database without any password which is much simpler than having another password. Use the space bar to select apache2, press Tab to select Ok, and then press Enter.
0 Comments
Leave a Reply. |