Versions Compared

Old Version 1

changes.mady.by.user Melissa Anez

Saved on

compared with

New Version 2

changes.mady.by.user Jaime Pinto

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

 Assuming MySQL database software is currently installed, execute the following:
 

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]
    Code Block
    languagesql
    $# 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
    titleCustomizing your MySQL setup