Skip to content

Instantly share code, notes, and snippets.

@geo-stanciu

geo-stanciu/mysql - set database utf8.sql

Created October 12, 2018 18:09
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save geo-stanciu/19f4fafb3bb11839648d1303870d3883 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save geo-stanciu/19f4fafb3bb11839648d1303870d3883 to your computer and use it in GitHub Desktop.
Download ZIP
mysql - set database utf8
Raw
mysql - set database utf8.sql
ALTER DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL PRIVILEGES ON dbname to 'geo'@'%';
GRANT ALL PRIVILEGES ON dbname.* to 'geo'@'%';
FLUSH PRIVILEGES;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment