Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL database setup instructions in README #24

Open
g-simmons opened this issue Jul 26, 2019 · 0 comments
Open

MySQL database setup instructions in README #24

g-simmons opened this issue Jul 26, 2019 · 0 comments

Comments

@g-simmons
Copy link

FYI setting up the database using the commands in the README threw an error about incorrect syntax near IDENTIFIED BY. As a result pyctd.update() asked for connection string.
SQL statements in the README:

CREATE DATABASE pyctd CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON pyctd.* TO 'pyctd_user'@'%' IDENTIFIED BY 'pyctd_passwd';
FLUSH PRIVILEGES;

Some googling indicates creating users via GRANT is deprecated behavior.

After using

CREATE DATABASE pyctd CHARACTER SET utf8 COLLATE utf8_general_ci;
CREATE USER 'pyctd_user'@'%' IDENTIFIED BY 'pyctd_passwd';
GRANT ALL PRIVILEGES ON pyctd.* TO 'pyctd_user'@'%';
FLUSH PRIVILEGES;

pyctd.update() looks like it's working as expected.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant