How to Create root password in mysql
-
Hi All
Greetings to you. I have created a ec2 login instance.i have installed mysql in ec2 instance.MySql Version no is
mysql Ver 14.14 Distrib 5.7.25, for Linux (x86_64) using EditLine wrapper
and i have to try to mysql -u root . It shows the error
ERROR 1045(20000) Access Denied for user ‘ root’ @ ‘localhost’ (using password:no)
and then try to
sudo mysql_mysecure_installation. It asks for password. when i just click the enter button(In Many Reference sites. They said. this command will help you set up the password).
I am facing problem in setup mysql. root with password.
There are so many updates are there. can any one help and provide the good link. for setup mysql user name and password.
Shall i have to change any php files for that.
thanks in advance
The page I need help with: [log in to see the link]
-
if you using phpmyadmin click the new at the top of the hierarchy tree on the left-hand side. it will take you to a database tab enter the name you want to call your database and press the create button.
Next, you will need a user. On the Hierarchy view on the left click on the database you just created then click on the add Privileges tab at the top of the screen. You should see a link at the bottom of the table to add user account.
click this button to create a new user just fill in the fields for the user for hostname select localhost. At the bottom of the screen you will have to assign privileges the user will have. If you are not sure you can click the check all button to give all privileges. When you are prompted in the setup just give the information you created for the database and user
- The topic ‘How to Create root password in mysql’ is closed to new replies.