Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 26th June 2006, 22:39
B4ssM4n B4ssM4n is offline
Junior Member
 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql root password problem>??

Hi,

I was going through the setting up a "perfect_setup_ubuntu_6.06_p4" and right at the bottom it mentions these two commands;

* mysqladmin -u root password yourrootsqlpassword
* mysqladmin -h itworkz.co.uk -u root password yourrootsqlpassword

However, I get these two messages;

* mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using password: NO)'
* mysqladmin: connect to server at 'itworkz.co.uk' failederror: 'Host 'itworkz.co.uk' is not allowed to connect to this MySQL server'

I take it "yourrootsqlpassword" is one i'm supposed to have setup? If so can you explain how I would go about setting these passwords, as I know these are very important!

This is the page in question --
http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p4

I'm new to Ubuntu but not scarred of command line executions so i'm hoping to learn quick fast I have beenusing windows since 3.1 missed out 95 straight to 98SE then XP played a bit with server edition - as i'm wanting to run my own server. After searching the net realised Linux does the best job and
have tested several version and settled for Ubuntu.
Reply With Quote
Sponsored Links
  #2  
Old 26th June 2006, 22:59
platd platd is offline
Member
 
Join Date: Apr 2006
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is mysql server up and running ?
Does
mysql
do any thing?
and what does
hostname
show ?
Reply With Quote
  #3  
Old 26th June 2006, 23:29
B4ssM4n B4ssM4n is offline
Junior Member
 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

My SQL after doing netstat -tap is showing as being up and available.

Hostname is showing a itworkz
Hostname -f is showing itworkz.co.uk

MySQL is running I have not turned it off.
Reply With Quote
  #4  
Old 26th June 2006, 23:36
platd platd is offline
Member
 
Join Date: Apr 2006
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If typing mysql drops you too a prompt like so
mysql>

Check docs here for securing it
http://dev.mysql.com/doc/refman/4.1/...rivileges.html
select docs for a version to fit your needs
Reply With Quote
  #5  
Old 26th June 2006, 23:39
B4ssM4n B4ssM4n is offline
Junior Member
 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I get this when typing mysql

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
Reply With Quote
  #6  
Old 26th June 2006, 23:43
platd platd is offline
Member
 
Join Date: Apr 2006
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

and
mysql -h itworkz.co.uk -u root -p

then supplying the pass you may have set gives ?

or

mysql -u root -p
Reply With Quote
  #7  
Old 26th June 2006, 23:49
B4ssM4n B4ssM4n is offline
Junior Member
 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I typed what was written exactly with out thinking so I put yourrootsqlpassword as password, doh!

after typing mysql -h itworkz.co.uk -u root -p I get >

ERROR 1130 (00000): Host 'itworkz.co.uk' is not allowed to connect to this MySQL server

and after

mysql -u root -p i get

Your MySQL connection id is 25 to server version: 5.0.22-Debian_0ubuntu6.06-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

and I used yourrootsqlpassword hmm

Proper screwed this up some how didn't I!!
Reply With Quote
  #8  
Old 26th June 2006, 23:54
platd platd is offline
Member
 
Join Date: Apr 2006
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's nothing major now you are in you can read up and secure it correctly
Hope it all works out for you
Reply With Quote
  #9  
Old 26th June 2006, 23:59
B4ssM4n B4ssM4n is offline
Junior Member
 
Join Date: Jun 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Cool thanks for your help man
Reply With Quote
  #10  
Old 27th June 2006, 12:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,735 Times in 2,571 Posts
 
Default

So it's working now?
__________________
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

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
monit howto Jamesk5 HOWTO-Related Questions 11 5th August 2008 15:10
Apache - Virtual hosts - ISPConfig Hans Server Operation 8 23rd April 2006 16:29
Problems installing NForce4 sound drivers Wraithfire Installation/Configuration 21 16th April 2006 17:30
How to install BFD (Brute Force Detection) domino Tips/Tricks/Mods 9 31st March 2006 22:40
Everything owned by root !!! wwparrish Installation/Configuration 6 7th February 2006 21:25


All times are GMT +2. The time now is 12:52.


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