Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th October 2012, 10:52
m4l41k4t m4l41k4t is offline
Member
 
Join Date: May 2012
Posts: 32
Thanks: 11
Thanked 0 Times in 0 Posts
Default [ask] MYSQL and PhpMyAdmin Problem Login

Dear;

I asked for his help, today I am having trouble with mysql and phpmyadmin.
1. login as root and the newly created user in the control panel ISPConfig in phpmyadmin or directly from a linux machine can not;
2. but if I try to test the login with a normal user who has gone before can be no problem. Its only the root user can't login and the newly created user..
3. The error occurs when login in phpmyadmin is "# 1045 Can not log in to the MySQL server"
4. The error occurs when login in linux machine:
root @ test: ~ # mysql-u root-p
Enter a password:
ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES)
root @ test: ~ #

The solution that I have done are:
1. Restart mysql service and try to restart the CPU can not be too;
2. I try to check from root @ test: ~ # tail-f /var/log/mysql.log messages appear no nothing;
3. I have tried the following but can not as well.
/etc/init.d/mysql stop
/usr/sbin/mysqld --skip-grant-tables --skip-networking &
mysql -u root mysql
FLUSH PRIVILEGES;
USE mysql UPDATE user SET Password = PASSWORD('newpwd') WHERE Host = '%' AND User = 'root';
FLUSH PRIVILEGES;
/etc/init.d/mysql stop
/etc/init.d/mysql start
4. I asked for his help what should i do
5. I'm using ISPConfig 3.0.4.6 and OS Ubuntu 12:04. My machine is running normally about 4 months and had a problem like this occurs.
ISPConfig installation when I use this tutorial: http://www.howtoforge.com/perfect-se...ispconfig-3-p4

Last edited by m4l41k4t; 5th October 2012 at 10:59.
Reply With Quote
Sponsored Links
  #2  
Old 11th October 2012, 08:47
m4l41k4t m4l41k4t is offline
Member
 
Join Date: May 2012
Posts: 32
Thanks: 11
Thanked 0 Times in 0 Posts
 
Default

I was hoping someone can give information as to date and still could not have done a few solutions
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Phpmyadmin does not connect to Mysql server Bashewa Installation/Configuration 23 27th November 2011 03:32
phpmyadmin stops authenticating, mysql does fine isn General 2 8th January 2010 16:57
Cannot login to phpmyadmin atjensen11 HOWTO-Related Questions 3 31st August 2009 18:07
phpmyadmin problem on ubuntu mail server virtual domains almeister9 HOWTO-Related Questions 1 19th September 2008 16:52
PHP problem or MySql problem , maybe both? reddog Server Operation 7 16th August 2006 09:21


All times are GMT +2. The time now is 03:56.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.