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 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
  #2  
Old 1st December 2010, 15:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,504
Thanks: 813
Thanked 5,265 Times in 4,129 Posts
Default

Looks as if you dont have a root user in your mysql setup anymore. You can check this e.g. with the command:

SELECT * FROM mysql.user WHERE User="root"

Quote:
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.
If you dont have a root user in mysql or the password is wrong, then ispconfig can not create databases as it logs into mysql to create the databases as root user.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 1st December 2010, 15:40
sellotape sellotape is offline
Member
 
Join Date: Oct 2010
Location: Maltby, UK
Posts: 65
Thanks: 12
Thanked 4 Times in 3 Posts
Default

Hi there Till.

Thanks for your help.
I wondered if user - root had been removed but don't remember removing it!

I am still quite new to command line and centos - can you tell me how I would go about recreating user root please?

Bearing in mind at present I am unable to login to MYSQL at all and only in safe mode.

Many thanks


Ash
Reply With Quote
  #4  
Old 2nd December 2010, 15:41
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
Default

http://forums.mysql.com/read.php?30,13701,62421
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

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 01:48.


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