apps:mysql
This is an old revision of the document!
Table of Contents
MySQL
Create new User+DB
Create a database with a user which have full access.
Example data:
- Username: u_example
- Password: WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L
- Databasename: db_example
Notes:
- I use prefix u_ for users and prefix db_ for databases that I never mix them up.
- I recommend passwords with 42 characters. They can be generated on http://strongpasswordgenerator.com/ for example.
CREATE USER 'u_example'@'localhost' IDENTIFIED BY 'WXJ07sf7lO7X4kzxjA47j7diQ4Z309628XS3Xm5D1L'; CREATE DATABASE db_example; GRANT ALL PRIVILEGES ON db_example.* TO 'u_example'@'localhost'; FLUSH PRIVILEGES;
Delete DB+USer
Example data:
- Username: u_example
- Databasename: db_example
DROP DATABASE db_example; DROP USER u_example@'localhost';
apps/mysql.1402952258.txt.gz · Last modified: 2014-12-18 20:10 (external edit)