Web Analytics Made Easy -
StatCounter Error during MySQL Setup... (Whackaxe?) - CodingForum

Announcement

Collapse
No announcement yet.

Error during MySQL Setup... (Whackaxe?)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error during MySQL Setup... (Whackaxe?)

    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; Jul 4, 2002, 12:08 PM.

  • #2
    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
    CodingForum Supreme Overlord
    All Hail Spookster

    Comment


    • #3
      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: '[email protected]' (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: '[email protected]' (Using password: YES)'

      help please?

      ~Quack

      Comment


      • #4
        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; Jul 3, 2002, 05:36 PM.
        photoshop too expensive? use the GIMP! www.gimp.org

        Comment


        • #5
          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

          Comment


          • #6
            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

            Comment


            • #7
              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
              CodingForum Supreme Overlord
              All Hail Spookster

              Comment


              • #8
                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

                Comment


                • #9
                  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

                  Comment


                  • #10
                    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
                    CodingForum Supreme Overlord
                    All Hail Spookster

                    Comment


                    • #11
                      The thing is that I need to keep my current configuation active .. is it possible to run both of them side by side?

                      ~Quack

                      Comment


                      • #12
                        I've run both of them before. I used phpdev for devoping php, mysql, perl stuff and used the other for asp stuff.
                        Spookster
                        CodingForum Supreme Overlord
                        All Hail Spookster

                        Comment


                        • #13
                          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

                          Comment


                          • #14
                            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
                            CodingForum Supreme Overlord
                            All Hail Spookster

                            Comment


                            • #15
                              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

                              Comment

                              Working...
                              X