The Percona MySQL server installation uses the wrong database initialisation which results in an unusable database system, since no root password is generated.
The installer generates the following warning: --bootstrap is deprecated. Please consider using --initialize instead While it uses the "-bootstrap" function to initialize the databases it skips the generation of a temporary root password in the /var/log/mysql/error.log file. After starting percona it is impossible to log in to the database. When I halt the percona db and remove the /var/mysql database directories and rerun the database initialisation with "mysqld --initialize --user=mysql --datadir=/var/mysql" it does generate the temporary root password in the logfile. Furthermore it would be nice that my.cnf is adjusted: Remove bind-address = 127.0.0.1 Remove skip_name_resolve Especially the last line, since the root user is inserted as root@localhost and not as [email protected] , so even with the temporary password you can still not log in. ------------------------------------------- smartos-discuss Archives: https://www.listbox.com/member/archive/184463/=now RSS Feed: https://www.listbox.com/member/archive/rss/184463/25769125-55cfbc00 Modify Your Subscription: https://www.listbox.com/member/?member_id=25769125&id_secret=25769125-7688e9fb Powered by Listbox: http://www.listbox.com
