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

Hi Alex

Thanks for your reply. (Sorry about the delay but for some reason 
yesterday I got no eMails in from the LO Forum???!!!)

On 20/02/13 20:44, Alexander Thurgood wrote:
> 1) Is your mysql server even running ?*  YES*
> >From the console/command line, try typing :
>
> ps aux | grep mysql
[ian@localhost ~]$ ps aux | grep mysql
root      2946  0.0  0.0   4260  1476 ?        S    10:17   0:00 /bin/sh 
/usr/bin/mysqld_safe --datadir=/var/lib/mysql --mysqld=mysqld 
--pid-file=/var/run/mysqld/mysqld.pid
mysql     3071  0.0  1.1 124144 23072 ?        Sl   10:17   0:00 
/usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql 
--log-error=/var/lib/mysql/localhost.localdomain.err 
--pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock 
--port=3306
ian       3537  0.0  1.8 198500 37676 ?        Sl   10:17   0:00 
/usr/sbin/mysqld 
--defaults-file=/home/ian/.local/share/akonadi/mysql.conf 
--datadir=/home/ian/.local/share/akonadi/db_data/ 
--socket=/home/ian/.local/share/akonadi/socket-localhost.localdomain/mysql.socket
ian       4805  0.0  0.0   4312   776 pts/1    S+   10:28   0:00 grep 
--color mysql

> 2) Now, from the same command line, try typing :
>
> mysql -p
>
> and enter the password for the current user. If your user didn't need a
> password, remove the -p
>
> Post the response here.
[ian@localhost ~]$ mysql -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
password: YES)
> 3)From the same command line, try typing :
>
> mysqladmin -p extended-status
>
> This should give a whole list of details about the running mysql server
> (if indeed it is running). Again, the -p parameter is only necessary if
> the user connecting to the mysql server requires a password to do so. If
> not, you  don't need the -p parameter.
I get the whole list of details as you mention.

What I think the problem is - is that I now have a new installation of 
MySQL and thus it does not yet have any users or passwords set-up in it.

So what I tried was...

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?????

Thanks for the help - appreciated

IanW
Pretoria RSA




--
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