CODEWITHSUNDEEP
phpmysqlphpmyadmin
Mikey
Mikey

Reputation: 47

How to create an account on phpMyAdmin?

I have a site at a hosting service and I want to work with phpmyAdmin. I copied the phpmyAdmin files in public_html. I entered www.mywebsite.com/phpmyAdmin, but it required a username and a password. How to create an account?

Upvotes: 0

Views: 14850

Answers (3)

SparkAndShine
SparkAndShine

Reputation: 18047

Login your machine, and try this

$ mysql -u root -p

mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
mysql> FLUSH PRIVILEGES;

Replace newuser and password with yours.

Upvotes: 1

Zinc
Zinc

Reputation: 385

If you used cPanel.

Login to your cPanel => Find Database => phpMyAdmin and click it, if you still got error you need to try asking the problem to your Host Provider.

Then if you want to access it from domain.com/phpmyadmin directly in the future, you can check your user account from User accounts on your phpMyAdmin navigation bar.

Then you can create a new user using Add new Account. After that, you can access your phpMyAdmin directly from domain.com/phpmyadmin without login to cPanel

And you can try to change your domain.com/phpmyadmin into domain.com/something, so other people will not easily access your phpMyAdmin

Upvotes: 0

Ariful Islam
Ariful Islam

Reputation: 913

IF you are using Cpanel. There is a option for accessing into your database by Phpmyadmin. Just Click on that. If you failed to get that. Then contact with your host provider regarding this issue.

Upvotes: 0

Related Questions