SOTL wrote:
>Hi All
>As usual truing to set up a new program I am lost in that I do not know what
>the program is suppose to do so I do not know if it is doing what it is
>suppose to but from the response I highly suspect that something strange is
>happening.
>
>The program is MySQL.
>
>I created a data base called frtestdb in the GUI version of MySglCC.
>I then tried to access it with the following results:
>Error 1045 Access denied for user trunk@localhost (using password: YES)
>
>The data base was created by using MySqlCC Console Manager by File -> New:
>NAME: frtestdb
>HOST NAME: localhost
>USER NAME: trunk [This is also the user name of the GUI user I am using]
>PASSWORD: password
>
>Ok that did not work so I went off to the command line.
>I started mysgl in the directory containing the frtestdb file.
>Then I issued the command:
>connect frtestdb
>
>And I received the following:
>Error 1044: Access denied for user @localhost
>
>
I am not a MySQL expert (or proponent), but I have used it. You might try:
mysql -u root@localhost
or
mysql -u root
Once you are in as a superuser, try:
grant all on frtestdb.* to trunk@localhost;
--ronan
-----------------------------------------------------------------------
This list is provided as an unmoderated internet service by Networked
Knowledge Systems (NKS). Views and opinions expressed in messages
posted are those of the author and do not necessarily reflect the
official policy or position of NKS or any of its employees.
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:31:47 EDT