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: [email protected]
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
