Can someone please tell me what is the password for SQL root
Can someone please tell me what is the password for SQL root host 3306? Or please tell how to reset? Cannot form any connection in SQL please help
Solution
Answer:
The best way to use it is :
> Open the terminal and type \" mysql -u root -p -h 127.0.0.1 -p 3306 \" without quotes. After connecting it we can get prompt where we can write password and press quite. But if we forgot the password then we can use this command to grant the permission :
mysql > GRANT ALL ON [DatabaseName].* to \'root\'@\'127.0.0.1\' IDENTIFIED BY \'[PASSWORD]\';
