Comments - mysql_install_db
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.
Have you checked file systems permissions?
I just went through this exercise, and it seems to me I had to mess with file system permissions.
Yes, Not sure how you can check permission on a directory that gets created when you run the install script. I can run the script as root or mysql and all the installation tables get created. I just always get the read only error.. even when mysql owns the data directory .
ERROR: 1005 Can't create table `mysql`.`innodb_table_stats` (errno: 165 "Table is read only")
-rw-rw---- 1 mysql mysql 16384 Jan 14 12:22 aria_log.00000001 -rw-rw---- 1 mysql mysql 52 Jan 14 12:22 aria_log_control -rw-rw---- 1 mysql mysql 12582912 Jan 14 12:22 ibdata1 -rw-rw---- 1 mysql mysql 50331648 Jan 14 12:22 ib_logfile0 -rw-rw---- 1 mysql mysql 50331648 Jan 14 12:22 ib_logfile1 drwx------ 2 mysql mysql 4096 Jan 14 12:22 mysql -rw-rw---- 1 mysql mysql 2241 Jan 14 12:22 mysqld.log drwx------ 2 mysql mysql 4096 Jan 14 12:22 test
Perms look right.
Do you have a working DNS? Did you try "--skip-name-resolve"?
Did you try "--verbose" to get more info about the problem?
Do you have a /etc/my.cnf set up? Did you try "--no-defaults" to rule out a problem with the config file?
I'm just shooting in the dark from reading the man page. (Did you RTFM? :-)
Thanks for the help... i got fed up with trying to guess what was causing it. it was a yum install by a coworker. I removed the packages and reinstall with the binaries. What worked fine. Thanks for the suggestions... I think it had to do with the my.cnf that was created with the yum. Thanks for all the help...
Glad you got it going.
Still, it's useful to figure this stuff out at your leisure, so you don't have to figure it out in a panic later... :-)