HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   Installation/Configuration (
-   -   Newbie hostname confusion mysql access denied (

shanegriffiths 15th August 2009 17:55

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:

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 -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 (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


Franz 15th August 2009 18:48

you nedd -p password option:

mysql -uuseeranme -ppasswprd

shanegriffiths 15th August 2009 18:57

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 ? 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

falko 16th August 2009 16:17

If you have a dynamic IP, you can get a hostname from

All times are GMT +2. The time now is 13:33.

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