Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error during MySQL Setup...

    I'm going through the PHP/MySQL tutorial on Webmonkey, and I got to the part where we create a DB - I'm getting this error though...

    C:\MYSQL\BIN>mysqladmin -u root create mydb
    MYSQLADMIN: connect to server at 'localhost' failed
    error: 'Can't connect to MySQL server on 'localhost' (
    Check that mysqld is running on localhost and that the
    You can check this by doing 'telnet localhost 3306'


    what do I do now??

    help please

    ~Quack
    Last edited by QuackHead; 07-04-2002 at 05:08 PM.

  • #2
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    You need to make sure mySQL is running before you can connect to it. Look in the folder where you installed it and find the startup file as it mentioned in the error.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #3
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    now I get this error...

    C:\MYSQL\BIN>mysqladmin -u root create mydb
    MYSQLADMIN: connect to server at 'localhost' failed
    error: 'Access denied for user: 'root@localhost' (Using password: NO)'

    when I use a password I get this

    C:\MYSQL\BIN>mysqladmin -u root -p[root] create mydb
    MYSQLADMIN: connect to server at 'localhost' failed
    error: 'Access denied for user: 'root@localhost' (Using password: YES)'

    help please?

    ~Quack

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    paris, france
    Posts
    1,216
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yes i think i had the same problem with my mysql. the thing is i hadnt set the password i think (i really dont want to go back and remeber that again ) anyways to set the password (under windoze if thats what your using quack)

    mysqladmin -u root password 'mynewpassword'

    after that you should be set. another thing is that when you start up the mySQL server use the winmysqladmin executable: it will open a managemnt system and also start up the mysl server executable (mysqld) it wil then show up as a set of traffic lights in the systray (red if the mysqld exec is not running and green if it is meaning your servers up!)

    also get the mysqlGUI from the mySQL site (its hideous and garish but its beter than command line) this is a perfect alternative to the countless different command lines execs there are in the /bin
    hope that does you. i found installing mySQL the hardest part because it is sooooooooo badly documented. hey jeewhiz couldnt you put a tutorial on how to install mysql on a mindows 9x system or i could do one if you want
    Last edited by whackaxe; 07-03-2002 at 10:36 PM.
    photoshop too expensive? use the GIMP! www.gimp.org

  • #5
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks - I still got an error from Dos, but I downloaded the GUI and it seemed to work for me to change my password.

    How do I create a DB from MySQL GUI ??

    thanks all help is MUCH appreciated!!!

    ~Quack

  • #6
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    k, I figured out how to make a DB from MySQL GUI, but I get the same error....

    can someone post some decent step by step directions of how to install MySQL and PHP ??

    This is really starting to bug me...

    thanks

    ~Quack

  • #7
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Unless you actually want to learn how to set up and configure all these I would just download phpdev4. It installs all of that already configured for you. Plus using phpMyAdmin is much easier to work with mySQL.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #8
    Regular Coder
    Join Date
    May 2002
    Location
    London, England
    Posts
    369
    Thanks
    0
    Thanked 0 Times in 0 Posts
    What spook forgot to say was the url

    www.firepages.com.au

    Enjoy

    Jee

    p.s., spook, don't worry dude, just getting old
    Jeewhizz - MySQL Moderator
    http://www.sitehq.co.uk
    PHP and MySQL Hosting

  • #9
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    phpdev4 - is this compatible with IIS ???

    Like I've said - I'm really new to this, so I don't really know what I'm doing

    ~Quack

  • #10
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Originally posted by Jeewhizz
    What spook forgot to say was the url

    www.firepages.com.au

    Enjoy

    Jee

    p.s., spook, don't worry dude, just getting old
    Yeah im getting forgetful in my old age.

    phpdev has it's own obviously superior web server Apache. If all you want to do is develop PHP/mySQL stuff and practice with it I would download that as it is all set up and configured for you. PHP and mySQL can run with IIS but you have to go through all the trouble of installing each of those and configuring them. If you want to learn how to do that then that's okay. But if you just want to be able to get started learning to write PHP and working with mySQL db's then I would just install phpdev.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #11
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The thing is that I need to keep my current configuation active .. is it possible to run both of them side by side?

    ~Quack

  • #12
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    I've run both of them before. I used phpdev for devoping php, mysql, perl stuff and used the other for asp stuff.
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #13
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok, well I think I'd like to see some instructions on doing it the other way - I tried in stalling phpdev but it didn't work...



    ~Quack

  • #14
    Supreme Overlord Spookster's Avatar
    Join Date
    May 2002
    Location
    Marion, IA USA
    Posts
    6,273
    Thanks
    4
    Thanked 83 Times in 82 Posts
    Ok to install each component individually as you intend you should read the documentation and installation instructions that comes with each one.

    As for phpdev it works just fine. If you give a better explanation than it don't work than we can help you get up and running.

    When I first installed phpdev I simply ran the install file and executed the batch file that starts Apache and MySQL and everything ran just fine. You did start everything right?
    Spookster
    CodingForums Supreme Overlord
    All Hail Spookster

  • #15
    Regular Coder
    Join Date
    Jun 2002
    Posts
    344
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yeah, I started everything properly, but it didn't link up to the right file (broken link on the start page...)

    Anyways, I think I'm just gunna give up on my PHP endevour..

    thanks for all your help though...

    ~Quack


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •