![]() ![]() You login in with this command:- Mysql -u root -p and past this command. rw-r-r- 1 apache apache 3981 Sep 3 07:59 config.inc. The same problem I faced but I founded one solution. ![]() Then login to the PHPMyadmin server as root and set up the credentials you wish to have for the users. Start the server with the skip-grant-table option. update root password: SET PASSWORD FOR 'root''localhost' PASSWORD ('YOUR NEW PASSWORD HERE') Share. The basic steps is to: Stop the mysql server. ![]() logging into my mysql server with my cli: mysql -u root -p. Next, I add a bit of garbage to the top of : I expect to see syntax error but nothing happened, thus I think phpMyAdmin just does not see/use this file. Sadly phpMyAdmin does not reflect the exact cause properly and just reports a failed connection 'Cannot log in to the MySQL server'. I hit the same issue on another server, but the message is a bit different: #2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)īut I have $cfg = '192.168.100.219' I also have a lot of free space available. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows executing SQL statements or managing users and. PhpMyAdmin is a free and open source tool written in PHP intended to handle the administration of MySQL with the use of a web browser. Tried both hostname and IP in $cfg = '10.188.8.207' PHPMyAdmin Error 1045 Cannot log in to the MySQL server. The database is NOT on the localhost but another server. I can also connect to the database server using the mysql -u. I have sites that can connect to the databases and are using them successfully. I have a website that is hosted off my desktop computer running linux ubuntu 11, it has apache 2, mysql and phpmyadmin installed with php5 I was using the phpmyadmin fine yesterday then today when I try to access my site's. I'm using phpMyAdmin-3.5.8.1 from default repository. 2002 Cannot log in to the MySQL server, PHPMyAdmin/MySQL. I can login to mysql server from command line by doing. The MySQL service on my CentOS 6.3 server works well. When I create a database I can access phpmyadmin from the ISPconfig panel by clicking the connection to phpmyadmin from the sites/database interface, but I cannot login with the username and password I just set up. ![]()
0 Comments
Leave a Reply. |