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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 1st December 2010, 15:22
sellotape sellotape is offline
Member
 
Join Date: Oct 2010
Location: Maltby, UK
Posts: 65
Thanks: 12
Thanked 4 Times in 3 Posts
Default Unable to login to MYSQL as root

Hi there.

I can't login as root - I know that my login details are correct but when I login it says permission denied.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

ISPConfig3.03 reports an error in red in the system log as...
2010-12-01 00:34 192.168.1.69 Error Unable to connect to the database:

I tried changing my root password by starting mysqld in safe mode as advised here...
Quote:
# /etc/init.d/mysqld stop
# /usr/bin/mysqld_safe --skip-grant-tables --skip-networking &
# mysql -u root
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD("your password here") WHERE User="root";
mysql> exit

# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start
However I get this message...

Code:
Query OK, 0 rows affected (0.00 sec)
Rows matched: 0  Changed: 0  Warnings: 0
I can login to the existing databases in ISPConfig 3.03 but when I attempt to create a new database - ISPConfig states it's all good to go but I am unable to login at all.

I'm not sure what to do next!

Thanks


Ash

Last edited by sellotape; 1st December 2010 at 15:33.
Reply With Quote
Sponsored Links
 

Bookmarks

Tags
ispconfig 3, mysql, phpmyadmin, root

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
apache log issues abubin General 13 1st August 2010 17:47
Update failed, lost client information (not the files) joosimol Installation/Configuration 10 25th January 2010 15:27
Perfect Server Ubuntu 9.10 ISPConfig2 AppArmor Issue dwtj01 HOWTO-Related Questions 9 18th November 2009 13:47
automatic webmail link admins Installation/Configuration 16 22nd June 2009 16:42
Postfix email server problems Access denied 554 554 5.7.1 state 14 AceRimmer Server Operation 4 19th June 2008 14:36


All times are GMT +2. The time now is 05:30.


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