Home mysql How to log in in phpmyAdmin?

How to log in in phpmyAdmin?




When entering phpmyAdmin , ask for a login and password. Where to take it from? I’m new, please explain in more detail.

Answer 1, Authority 100%

Login: root
Password: root


Login: MySQL
Password: MySQL

Well, or sometimes even so

Login: root
Empty password

In general, PhpmyAdmin asks access to your database.
Accordingly, the username and password must be specified for the used database user.
Or standard i indicated above.

if it gives an error

2002 Cannot Log In To The MySQL Server

Edit the file phpmyadmin / config.inc.php , replacing this line:

$ cfg ['servers'] [$ i] ['host'] = 'localhost';

on this:

$ CFG ['Servers'] [$ i] ['host'] = '';

Full Listing

& lt;? php
$ CFG ['blowfish_secret'] = 'BA17C1EC07D65003'; // Use Here A Value of Your Choice
$ i = 0; $ i ++;
$ CFG ['Servers'] [$ i] ['auth_type'] = 'Cookie';
$ CFG ['Servers'] [$ i] ['Host'] = '';
$ CFG ['Servers'] [$ i] ['port'] = '3307'; // MySql Port.
? & gt;

You may have edited MySQL configuration file so that it starts on another port. In this case, the new port must be specified in the phpMyAdmin configuration file (see the last line of the listing above).

In addition, the configuration file itself config.inc.php must lie in the root folder phpMyAdmin.

Before the start of PhpMyadmin MySQL must already be launched. Check if the corresponding process is in the task manager.

Check if the user has, on behalf of which you try to log in, relevant rights.

If all of the above did not help, mysql himself mowed crookedly. Try to reinstall it.

Answer 2, Authority 33%

In Ubuntu, we do this:

$ cd / etc / mysql /
$ sudo vim debian.cnf

And here is the answer:

Automatically Generated for Debian Scripts. Do Not Touch!

Host = Localhost.
User = Debian-Sys-Maint // This is a user
password = utjaxfyqfsyssjoz // is a password
socket = /var/run/mysqld/mysqld.sock< ;br>
Host = Localhost.
User = Debian-Sys-Maint // This is a user
password = utjaxfyqfsyssjoz // is a password
socket = /var/run/mysqld/mysqld.sock

Answer 3, Authority 8%

This thing has helped me in the settings:
Login: root.
Empty password

Thank you

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions