« jEdit Is My New IDE |
Fedora Core 6 Kernel 2.6.20 and ATI Driver 8.34 for Radeon 200M »
Setting up MySQL in Fedora Core 6
I decided to develop a web portal that runs off of my laptop for my personal use. Since it is the only computer I use for business, it seemed like the logical direction to take. One problem that I have always had when developing a server setup is getting MySQL to do what it is supposed to do. Here is my personal documentation so hopefully I will not have to suffer with it again. This post is about Fedora Core, so I will include the yum statements I used. For other distros, just install the equivalent packages.
[root@localhost ~]# yum install mysql mysql-devel mysql-serverNow, I am going to start the MySQL server and set it up to start everytime I boot.
[root@localhost ~]# service mysqld start
Starting MySQL: [ OK ]
[root@localhost ~]# chkconfig mysqld onNow I need to set the password for the root user:
[root@localhost ~]# mysqladmin -u root password yourpasswordSince I am going to install Drupal as a CMS for my personal portal, I am going to need a database for the installation. I will create a database named ‘drupal’ and then create a user account for this database called ‘duser’. It is not recommended that you use the root account for accessing your MySQL databases.
[root@localhost ~]# mysql -u root -p
Enter password:
mysql>; CREATE DATABASE drupal;
Query OK, 1 row affected (0.09 sec)
mysql> GRANT ALL PRIVILEGES ON drupal.*
-> TO 'duser'@'localhost' IDENTIFIED BY
->'yourpassword' WITH GRANT OPTION;
Query OK, 0 rows affected (0.01 sec)
mysql> quit
ByeThat’s all there is to it. After that, I put the access information that I just created into Drupal’s database configuration page and it installed the CMS for me.
Share: del.icio.us | digg | reddit
Thanks for you info……………..:)