MySQL: Difference between revisions
Jump to navigation
Jump to search
(New page: ==== Creating new MySQL databases ==== $ mysql -uroot -pSECRET-PASSWORD > CREATE DATABASE someusername; > GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY...) |
No edit summary |
||
| Line 1: | Line 1: | ||
==== Creating new MySQL databases ==== |
==== Creating new MySQL databases ==== |
||
$ mysql -uroot - |
$ mysql -uroot -p |
||
Enter password: ****** |
|||
| ⚫ | |||
| ⚫ | |||
| ⚫ | |||
Query OK, 1 row affected (0.00 sec) |
|||
| ⚫ | |||
Query OK, 0 rows affected (0.06 sec) |
|||
For random passwords run 'makepasswd --chars 20'. For the administrative password for the cluster see /users/sysadmin/passwords/mysql. |
For random passwords run 'makepasswd --chars 20'. For the administrative password for the cluster see /users/sysadmin/passwords/mysql. |
||
Write a file to the club's homedir readable only by them containing the following: |
|||
Username: clubuserid |
|||
Password: longrandompassword |
|||
Hostname: localhost |
|||
Revision as of 15:20, 9 July 2009
Creating new MySQL databases
$ mysql -uroot -p Enter password: ******
mysql> CREATE DATABASE someusername; Query OK, 1 row affected (0.00 sec)
mysql> GRANT ALL PRIVILEGES ON someusername.* to someusername@localhost IDENTIFIED BY 'longrandompassword'; Query OK, 0 rows affected (0.06 sec)
For random passwords run 'makepasswd --chars 20'. For the administrative password for the cluster see /users/sysadmin/passwords/mysql.
Write a file to the club's homedir readable only by them containing the following:
Username: clubuserid Password: longrandompassword Hostname: localhost