Thank you for logging that, I ran into the same issue. (And this was after abandoning the pre-built percona image - may or may not have been related, mind).
SSH'd on the host, I had to zlogin with the -C(onsole) option, then was able to GRANT to 'root'@'127.0.0.1', etc. On Wed, Dec 14, 2016 at 3:09 AM, the outsider <[email protected]> wrote: > 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> > <https://www.listbox.com/member/archive/rss/184463/28444572-979c7f91> | > Modify > <https://www.listbox.com/member/?&;> > Your Subscription <http://www.listbox.com> > ------------------------------------------- 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
