2006-09-07
Previously, in MySQL
To create a user jsmith with password Secret15 and allow them to do anything with the database named accounts, connect to the database with mysql and issue the command:mysql> grant all on accounts.* to jsmith@localhost identified by 'Secret15';
Update for Mysql 8 or something
2023-05-09You can't indirectly create users through a grant any more.mysql> create user mydbadmin@'%' identified by 'superSecretPasswordWord'; Query OK, 0 rows affected, 1 warning (0.01 sec)mysql> grant all privileges on mydb.* to mydbadmin@'%'; Query OK, 0 rows affected (0.00 sec)
no comments |
post comment
Virtual Dave Megaplex:
Home Page- This wiki's start page
- Send Feedback To Dave
Logged in Users: (0)
Recently Changed
SSL Certificate Bundles- Seconds Since Epoch to Local Time
- ufw
- Grow A LVM Partition
- Creating Users
- whoami
- list databases
- DH Selection For IPsec VPNs
- 2023
- 2022
- 2019
- 2018
- 2017
- 2011
- 2010
- 2008
- 2001
- 2000
- 1999
- 1991
- Fire Eater
- Custom '77 Dodge Van
- Bone Shaker
- Batmobile
- Fire Eater Wanted
- dvr-scan
- Batmobiles Wanted
- 2021
- 2020
- 2016
Editing: snipsnap-help, Image Macro(Et auditum est, et idcirco ego nunc simulare)
This is a collection of techical information, much of it learned the hard way. Consider it a lab book or a /info directory. I doubt much of it will be of use to anyone else.