Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th August 2009, 17:55
shanegriffiths shanegriffiths is offline
Junior Member
 
Join Date: Aug 2009
Location: Taunton, Somerset UK
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via Skype™ to shanegriffiths
Default Newbie hostname confusion mysql access denied

Hi All

I am a keen web developer that wanted to set up his own local dev server at home.

I have been following the tutorial on here: http://www.howtoforge.com/perfect-se...ispconfig-2-p4

As you can see i am using fedora 11 but with 32bit i386 version

At the beginning i was pretty confused as to what my hostname should be. I am on a normal average joe home network with a sky (my ISP) router, DHCP, no domain just everything housed within a windows workgroup (called SGNET).

I decided to call the hostname "webdev" - i suspect i have gone wrong here lol

everything seemed fine until i installed mysql and tried to run the following command:

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

- i received an error saying: connect to server at 'webdev' failed error: 'access denied for user 'root'@' localhost' (using password: NO)

I think i am confused with what hostname is needed to put for my type of network. I am running DHCP through the router.

What i really want is to call my server dev.83pixels.com (which is the name of my website which is hosted with a proper hosting company but i thought i would start small and get everything working internally first before i look at external names.

If anyone could provide any help it would be much appreciated ! I really want to progress with Linux

Kindest regards

Shane
Reply With Quote
Sponsored Links
  #2  
Old 15th August 2009, 18:48
Franz Franz is offline
Senior Member
 
Join Date: Jul 2009
Location: Cakovec
Posts: 117
Thanks: 7
Thanked 24 Times in 18 Posts
Send a message via Skype™ to Franz
Default

you nedd -p password option:

mysql -uuseeranme -ppasswprd
__________________
my PAGE
VoIP
my IT help blog
Reply With Quote
The Following User Says Thank You to Franz For This Useful Post:
shanegriffiths (15th August 2009)
  #3  
Old 15th August 2009, 18:57
shanegriffiths shanegriffiths is offline
Junior Member
 
Join Date: Aug 2009
Location: Taunton, Somerset UK
Posts: 2
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via Skype™ to shanegriffiths
Default

Ahh , thats it ! thank you so much !!

I don't suppose you have any advice on hostnames ? Mine is called just webdev.

do you how i would eventually be able to use http://dev.83pixels.com ? will i need a static external IP / dynDNS ? - would this be configured on my hosting server ? (i.e. 123-reg)

Any help would be fantastic , thank you
Reply With Quote
  #4  
Old 16th August 2009, 16:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
 
Default

If you have a dynamic IP, you can get a hostname from dyndns.org.
__________________
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
fedora, hostname, newbie

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
postfix/trivial-rewrite digitalage HOWTO-Related Questions 19 13th March 2013 20:02
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
ISP Config hesitation when opening web pages frankb Installation/Configuration 7 15th December 2008 14:06
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Questions in regards to ISP-Server Setup - Ubuntu 5.10 "Breezy Badger" rbrantley HOWTO-Related Questions 16 10th April 2006 19:26


All times are GMT +2. The time now is 14:27.


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