DGenerateKane
Explorer
- Joined
- Sep 4, 2014
- Messages
- 95
I've had a mysql 5.5 server installed in a jail for over three years now for my Kodi installs, but my machine is running 11.1-U7 so it's in a Warden jail. Before breaking my Kodi installs I wanted to make sure I could properly install mysql 5.7 in an iocage jail, so I updated my other machine to 11.2-U8 and attempted installing mysql there. When I installed the original mysql server, I followed the guide here https://kodi.wiki/view/MySQL/Setting_up_MySQL#tab=FreeNAS_and_freeBSD but that is horribly outdated and isn't possible to follow precisely. I've searched a lot and finally got it installed and running mostly, but the last set of steps on the Kodi wiki are where I'm stuck. When I enter the command:
I get the error:
After more searching I tried this command:
Even though I had previously set the policy to the lowest, I had to change my password to a mix of upper and lowercase letters, numbers and symbols before it would work. However when I tried the CREATE USER command again, I get the exact same error message, so I'm now at a loss on how to proceed. What am I missing?
CREATE USER 'kodi' IDENTIFIED BY 'kodi';
I get the error:
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
After more searching I tried this command:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
Even though I had previously set the policy to the lowest, I had to change my password to a mix of upper and lowercase letters, numbers and symbols before it would work. However when I tried the CREATE USER command again, I get the exact same error message, so I'm now at a loss on how to proceed. What am I missing?