Info |
---|
title | Editor's "To Do" list |
---|
|
- create dedicated sub page dedicated to MySQL setup for Fedora
- edit code block to show connecting to MySQL database server
- add notes for users to know what needs to be adjusted for customizing (i.e. [your-mysql-user])
|
To setup the MySQL Database for Fedora...
Assuming MySQL database software is currently installed, execute the following:
Code Block |
---|
|
$# mysql -u root [your-mysql-user]-p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 68
Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database [fedoradatabase];
mysql> GRANT ALL ON [fedoradatabase].* TO [fedoradbuser] IDENTIFIED BY [password]; fedora3;
Query OK, 1 row affected (0.00 sec)
mysql> create user 'fedoraAdmin'@'%' identified by 'password';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all on fedora3.* to 'fedoraAdmin'@'%';
Query OK, 0 rows affected (0.00 sec)
mysql> alter database fedora3 default character set utf8;
Query OK, 1 row affected (0.01 sec)
mysql> alter database fedora3 default collate utf8_bin;
Query OK, 1 row affected (0.00 sec)
mysql> flush privileges;
mysql> exit |
Note |
---|
title | Customizing your MySQL setup |
---|
|
Be sure to change:
[your-mysql-user] to whatever MySQL User you use to manage your MySQL installation[fedoradatabase] to the name of the database Fedora will use to store its data[fedoradbuser] to the MySQL User that Fedora will use to manage the its data[password] to the password that [fedoradbuser] will use to connect to [fedoradatabase]