MySql update...

[tenfoot]

Hi!

For some reason I edited my message of 9 July instead of doing a "Reply" and notice that the date hasn't changed.

The purpose of this post is to point members to the edited post, in case they are able to offer further assistance.

Thanks for reading.

[DataMan]

?

[tenfoot]

?

Yes,I can understand your query So I seek the indulgence of members and copy below the edit I did on the original reply to DrHu.

Re: MySql...

Post by tenfoot on Thu Jul 09, 2009 8:13 pm
Hi DrHu

Thanks again for a very prompt response.

There is so much to take aboard that I've printed your posts and will work through all the suggestions. Again, I'll report back when I have done so.


This is my report back.

This is very long, so my apologies for taking up so much bandwidth.

Using the instructions provided , I got VetTux installed but I'm still having problems with MySql

Here are the results of various attempts to get it working.

(1) If I type the command without an argument

Code: Select all

 zed@zed-desktop ~ $ mysql
    ERROR 1045 (28000): Access denied for user 'zed'@'localhost' (using password: NO)

(2) If I type the command with the -p argument

Code: Select all

 zed@zed-desktop ~ $ mysql -p
    Enter password:
    ERROR 1045 (28000): Access denied for user 'zed'@'localhost' (using password: YES)

(3) If I log in first and then type the command without an argument

Code: Select all

 zed@zed-desktop ~ $ sudo -s
    [sudo] password for zed:
    zed-desktop ~ # mysql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

(4) If I type the command using the -p argument (Note I am asked to enter the password again, even though I am in root)

Code: Select all

zed-desktop ~ # mysql -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 32
    Server version: 5.0.75-0ubuntu10.2 (Ubuntu)

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

    mysql> 

(5) If I then type \h I get a whole list of commands, thus

Code: Select all

 mysql> \h

    For information about MySQL products and services, visit:
       http://www.mysql.com/
    For developer information, including the MySQL Reference Manual, visit:
       http://dev.mysql.com/
    To buy MySQL Network Support, training, or other products, visit:
       https://shop.mysql.com/

    List of all MySQL commands:
    Note that all text commands must be first on line and end with ';'
    ?         (\?) Synonym for `help'.
    clear     (\c) Clear command.
    connect   (\r) Reconnect to the server. Optional arguments are db and host.
    delimiter (\d) Set statement delimiter. NOTE: Takes the rest of the line as new delimiter.
    edit      (\e) Edit command with $EDITOR.
    ego       (\G) Send command to mysql server, display result vertically.
    exit      (\q) Exit mysql. Same as quit.
    go        (\g) Send command to mysql server.
    help      (\h) Display this help.
    nopager   (\n) Disable pager, print to stdout.
    notee     (\t) Don't write into outfile.
    pager     (\P) Set PAGER [to_pager]. Print the query results via PAGER.
    print     (\p) Print current command.
    prompt    (\R) Change your mysql prompt.
    quit      (\q) Quit mysql.
    rehash    (\#) Rebuild completion hash.
    source    (\.) Execute an SQL script file. Takes a file name as an argument.
    status    (\s) Get status information from the server.
    system    (\!) Execute a system shell command.
    tee       (\T) Set outfile [to_outfile]. Append everything into given outfile.
    use       (\u) Use another database. Takes database name as argument.
    charset   (\C) Switch to another charset. Might be needed for processing binlog with multi-byte charsets.
    warnings  (\W) Show warnings after every statement.
    nowarning (\w) Don't show warnings after every statement.

    For server side help, type 'help contents'

    mysql> 

(6) I want to use the dvVetTux database but if I type \connect dbVetTux I get

Code: Select all

mysql> \connect dbVetTux;

    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'onnect dbVetTux' at line 1

    mysql> 

Note the the error ouptut drops the initial letter of the command, i.e. it is shown as onnect.

(7) At that stage I entered the \quit command to exit mysql.

VetTux has a configuration utility named dbVetTux and clicking on it opens a dialogue
box, giving me an opportunity to setup a database. Going through the
options leads eventually to an error, inasmuch as whether I use root as the
Administrator Name, with the root password (or no password) or use the user name (zed) and
the password for that user. The error message reads: "The VetTux database
could not be created as it was unable to connect to the MySQL server using
the details provided. This wizard has no option but to terminate."

I've searched Google for "set up mysql" and "configure mysql" but, apart from the fact they appear very technical" can find nothing that assists me.

I've uninstalled both MySql-Client and MySql-Server and then reinstalled them, choosing to leave the option to enter a password blank but that hasn't solved my problem.

Any help appreciated.