[libreoffice-users] Re: Re-Connecting LO Base to an SQL DB

Le 21/02/2013 09:57, Ian Whitfield a écrit :

Hi Ian,

> mysql> CREATE USER 'ianw'@'localhost' IDENTIFIED BY 'pwd';
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> GRANT ALL ON db1.* TO 'ianw'@'localhost';
> Query OK, 0 rows affected (0.00 sec)
>
> But when I try to get into MyAdmin with this user and pwd I get
>
> #1045 Cannot log in to the MySQL server
>
> I'm stumped?????

Forget phpmyadmin (what PCLinuxOS seems to call MyAdmin, don't
understand why they renamed it and be the only distrib to do so ?) for
the moment.

> From the console/command line, try to connect as the user ian that you
just created :

mysql -u ianw -p


Can you connect to mysql as user ianw from the command line ?

Alex



-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted