Distro is Mageia2 and 4.
Its the "datadir" that defines the location of the database
not "basedir" also is '/home/barry/.local/share/akonadi/db_data/mysql'
a soft link to your datadir?
my.cnf basic options are
user=mysql
basedir=/usr
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
port=3306
pid-file=/var/run/mysqld/mysqld.pid
log-error=/var/log/mysqld.log
There should be error messages not machine code in the
log it might help to drop the use of ./bin/mysql_install_db --general-log
option and let it log to mysqld.log not just for error messages it
should log
it is "ready for connections".
Distros vary with log location /var/log, /var/log/mysql or /var/lib/mysql
but the my.cnf should define it.
When you run mysql_install_db it should output any perm errors.
Other tests
ps -ef | grep mysql (check server is running)
netstat -lnp | grep 3306 (check open ports)
mysqladmin -u root -p status (info uptime and open tables)
---
keith.
On 29/05/15 21:32, Barry wrote:
Hi all could someone please elucidate for me on what is happening when
I try to set up mysql.
As root I cd to /usr, then run ./bin/mysql_install_db --general-log.
this returns 'Installing MariaDB/MySQL system tables in
'/var/lib/mysql' ...' but nothing turns up there!
After many days trying, and searching I found the files in
'/home/barry/.local/share/akonadi/db_data/mysql' although in my.cfg
the server base directory is set to /usr
This has occurred on both the mageia2 and mageia4 distros. The 3
general-log files are of no use they only contain machine code. As it
appears I may have tried this last year I tried renaming the mysql db
and rerunning the cmd but no joy.
Can someone help please.
TIA
Barry _______________________________________________
Linux-users mailing list
[email protected]
http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
_______________________________________________
Linux-users mailing list
[email protected]
http://lists.canterbury.ac.nz/mailman/listinfo/linux-users
