SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Jun 2001
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Connecting MySql

    So here I am trying to set a root password for mysql and I am looking at something like this:

    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 18 to server version: 3.23.38-max-debug

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

    mysql>

    and I type at the prompt:

    mysql> mysqladmin -u root password "this is secret";

    then I get:
    ERROR 1064: You have an error in your SQL syntax near 'mysqladmin -u root password "this is secret"' at line 1
    mysql>

    What am I doing wrong?

  2. #2
    SitePoint Member
    Join Date
    Jun 2001
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    oops

    I just realized that the title was very misleading. That is because I was working from the dos prompt c:\mysql\bin>, I stop getting the connection failed problem after I typed in mysql-opt and mysql again. But this one I can't figure out.

  3. #3
    Victory shall be mine tubedogg's Avatar
    Join Date
    Mar 2001
    Location
    Medina, OH
    Posts
    440
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mysqladmin is a separate binary. You execute it from the command prompt, not from within the mysql binary.

    So at the c:\mysql\bin> prompt you type the mysqladmin line.
    Kevin


Bookmarks

Posting Permissions

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