Not the answer you need?
Register and ask your own question!

Newbie: change data dir and user.

GrayWolf82GrayWolf82 EntrantCurrent User Role Contributor
Hi. I need change data dir for percona. But, when i do init with this patameters:

sudo mysqld --initialize --user=[user] --basedir=/home/[user]/percona --datadir=/home/[user]/percona/base

i can`t connect to database: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES).
But, when i do like that: sudo mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql all work good

And one more question: how to change mysql user to [user]? It is necessary that the perсona work on behalf of the user [user]
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.