tag:blogger.com,1999:blog-11430866.post-1149607888759335022006-06-06T08:31:00.000-07:002006-06-06T08:41:09.076-07:00http://stanton-finley.net/fedora_core_5_installation_notes.html<br />Web Server: <ul class="list"> <li>The Apache web server is available for Fedora Core 5. If you have not already done so go to "Applications" > "Add/Remove Software", enter your root password, then under "Servers" tick the check box for "Web Server", click "Optional Packages" and tick all the check boxes, click "Close", click "Apply" and "Continue". Go to "System" > "Administration" > "Security Level and Firewall". Provide your root password, click "ok" and on the "Firewall Options" tab make sure the check boxes next to "WWW (HTTP)" and "Secure WWW (HTTPS) are ticked. On the "SELinux" tab click the arrow on the left of "Modify SELinux Policy" and under (expanded) "HTTPD Service" make sure all the checkboxes are ticked except "Disable SELinux protection for httpd daemon" and "Disable SELinux protection for http suexec". (Please see <a href="http://fedora.redhat.com/docs/selinux-faq-fc5/">http://fedora.redhat.com/docs/selinux-faq-fc5/</a> for important SELinux considerations.) Click "ok". Reboot your machine to enable the new SELinux settings.</li> </ul> <ul class="list"> <li>Subscribe to a service such as <a href="https://www.dyndns.org/">https://www.dyndns.org/</a> or <a href="http://www.easydns.com/">http://www.easydns.com/</a> to register a new domain name (such as your-name.org) and to have their DNS service map your computer's IP address to your new registered domain name. (The command "ifconfig" at the root prompt will output your IP address.) If you have a "dynamic" (changeable) IP address you can use their dynamic DNS service.</li> </ul> <ul class="list"> <li>If you are using a router you may have to forward ports 80, 8080, and 443 in order for your web server to work through your router's firewall. See <a href="http://www.portforward.com/routers.htm">http://www.portforward.com/routers.htm</a> for instructions.</li> </ul> <ul class="list"> <li>Open the terminal. Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. Type your root password. Hit enter. Type "ifconfig". Hit enter. This will output the IP address of your machine (the numbers after "inet addr:") or if you are behind a router or gateway go to <a href="http://checkip.dyndns.org/">http://checkip.dyndns.org/</a> or <a href="http://myipaddress.com/">http://myipaddress.com/</a> to determine the IP address that the outside world sees for your machine and use that as your IP address in the following. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /etc/hosts<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>In gedit edit your /etc/hosts file to include a line containing your IP address, your domain name, and your short domain name (the characters before the dot). Be sure to include a carriage return after this line. When you are finished your hosts file should look something like this: <div class="bordered"> <pre># Do not remove the following line, or various programs<br /># that require network functionality will fail.<br />127.0.0.1 localhost.localdomain localhost<br />67.172.236.37 stantonfinley.org stantonfinley<br /><br /></pre> </div>Be sure there is a blank line at the end of the file. Click on the "save" icon in gedit and exit gedit. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /etc/sysconfig/network<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>In gedit edit your /etc/sysconfig/network file and replace "localhost.localdomain" with your domain name. When you are finished your network file should look something like this: <div class="bordered"> <pre>NETWORKING=yes<br />HOSTNAME=stantonfinley.org<br /></pre> </div>Click on the "save" icon in gedit and exit gedit. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /etc/httpd/conf/httpd.conf<br /></pre> </div>Hit enter. Go to "File" > "Save As...", type "httpd.conf.original" in the "Save As..." box and click "Save". This creates a backup of your httpd.conf file. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /etc/httpd/conf/httpd.conf<br /></pre> </div>Hit enter. (You are about to edit your Apache web server configuration file. Please see <a href="http://httpd.apache.org/docs/2.0/">http://httpd.apache.org/docs/2.0/</a> for important information about what the configuration lines we are about to edit do.) </li> </ul> <ul class="list"> <li>In gedit scroll down to the "ServerAdmin" section and enter your email address instead of "root@localhost". <p>Scroll down to the "#ServerName" section and uncomment it (take out the "#"). Then enter the registered DNS name of your web site ("whatever.com") or your server's IP address instead of "www.example.com". (If you don't know your IP address type "ifconfig" at the root prompt.)</p> <p>Scroll down and change "UseCanonicalName Off" to "UseCanonicalName On".</p> <p>Scroll down to the "Options" line and change "Options Indexes FollowSymLinks" to "Options Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews".</p> <p>Change "AllowOverride None" to "AllowOverride Options FileInfo AuthConfig Limit" in case you want to use .htaccess files in any of your web subdirectories.</p> <p>Change "DirectoryIndex index.html index.html.var" to "DirectoryIndex index.html index.html.var index.shtml index.cgi index.php index.phtml index.php3 index.htm home.html welcome.html".</p> <p>Under the "AddType application/x-compress .Z" and "AddType application/x-gzip .gz .tgz" lines add the line: "AddType application/x-httpd-php .php .phps .php3 .phtml .html .htm .shtml .fds".</p> <p>Uncomment the line "#AddHandler cgi-script .cgi" and add ".pl" so that it reads "AddHandler cgi-script .cgi .pl".</p> <p>If you wish to enable support to serve web pages from user's home directories as well comment (add a "#" in front of) "UserDir disable" so that it reads "#UserDir disable" and uncomment "#UserDir public_html" so that it reads "UserDir public_html". Then uncomment and edit the control access stanza for user directories below it so that it looks something like this:</p> <div class="bordered"> <pre><directory><br /> AllowOverride Options FileInfo AuthConfig Limit<br /> Options Indexes Includes FollowSymLinks SymLinksifOwnerMatch ExecCGI MultiViews<br /> <limit><br /> Order allow,deny<br /> Allow from all<br /> </limit><br /> <limitexcept><br /> Order deny,allow<br /> Allow from all<br /> </limitexcept><br /></directory><br /></pre> </div>Click on the "save" icon in gedit to save your httpd.conf file and exit gedit. Close the terminal. </li> </ul> <ul class="list"> <li>Open a terminal as your regular user (not root). Type: <div class="bordered"> <pre>mkdir public_html<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>chmod -R 755 public_html<br /></pre> </div>Hit enter. Close the terminal. </li> </ul> <ul class="list"> <li>Open the terminal. Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. Type your root password. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>cd /home<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>chmod 711 your_user_name<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>chcon -R -t httpd_user_content_t /home/your_user_name/public_html/<br /></pre> </div>(Use the name of the user's home directory you are working with in place of "your_user_name".) Hit enter. Close the terminal. </li> </ul> <ul class="list"> <li>If you have a favicon.ico copy it to /var/www/html while still logged in as root (cp favicon.ico /var/www/html).</li> </ul> <ul class="list"> <li>Go to "System" > "Administration" > "Server Settings" > "Services". Type in your root password in the dialog box that appears and click on "OK". Scroll down the list and tick the check box for "httpd". Also untick the check box for "thttpd" if it is ticked. Click on the "save" icon in the Service Configuration window and then close the window. Do this for runlevel 3 as well as for runlevel 5. Reboot your machine or issue the command "service httpd start" as root to start the Apache web server.</li> </ul> <ul class="list"> <li>Open Firefox and type your server's IP address in the URL window and hit enter. You should see the default Apache/Fedora Core test page. Type the registered DNS name of your web site ("whatever.com") in the URL window and hit enter. You should see the test page again.</li> </ul> <ul class="list"> <li>While still logged in as root copy or move your web site index.html and any other HTTP content you may have to /var/www/html and/or to /home/your_user_name/public_html. Change permissions on these files to be viewable and executable as appropriate on the web (usually "chmod 755 *"). You are now serving web pages from your Fedora Core web server. You will find your server log files in /etc/httpd/logs and you will be able to view them while logged in as root.</li> </ul> <div class="heading"> <a id="FTP" name="FTP"></a>FTP Server: </div> <ul class="list"> <li>The secure FTP server vsftpd is available in Fedora Core. If you have not already done so go to Applications" > "Add/Remove Software", enter your root password, then under "Servers" tick the check box for "FTP Server", click "Close", click "Apply" and "Continue". Go to "System" > "Administration" > "Security Level and Firewall". Provide your root password, click "ok" and on the "Firewall Options" tab make sure the check boxes next to "FTP" is ticked. On the "SELinux" tab click the arrow on the left of "Modify SELinux Policy" and under (expanded) "FTP" make sure all the checkboxes are ticked except "Disable SELinux protection for ftpd daemon". Click "ok". Reboot your machine to enable the new SELinux settings.</li> </ul> <ul class="list"> <li>If you are using a router you may have to forward ports 20 and 21 in order for your FTP server to work through your router's firewall. See <a href="http://www.portforward.com/routers.htm">http://www.portforward.com/routers.htm</a> for instructions.</li> </ul> <ul class="list"> <li>Register a new domain name for your Fedora box, have it mapped to your IP address, and configure your /etc/hosts and /etc/sysconfig/network files as described in the web server section above.</li> </ul> <ul class="list"> <li>Open the terminal. Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /etc/vsftpd/vsftpd.conf<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>In gedit change "anonymous_enable=YES" to "anonymous_enable=NO". <p>Also add a line that reads "chroot_local_user=YES" just under the line that reads "#chroot_list_file=/etc/vsftpd/chroot_list".</p> <p>Also uncomment (remove the "#" from) the ascii_ lines so that they read "ascii_upload_enable=YES" and "ascii_download_enable=YES".</p>Click on the "save" icon in gedit to save your vsftpd.conf file and exit gedit. Close the terminal. </li> </ul> <ul class="list"> <li>Go to "System" > "Administration" > "Server Settings" > "Services". Type in your root password in the dialog box that appears and click on "OK". Scroll down the list and check the check box for "vsftpd". Click on the "save" icon in the Service Configuration window and then close the window. Do this for runlevel 3 as well as for runlevel 5. Reboot your machine. You should now be able to access your home user's directory with an FTP client. The host name on your client will be your registered domain name or the IP address of your Fedora Core box. The user ID will be your Fedora Core non-root user name. The password will be your Fedora Core non-root user's password. (I recommend turning off passive mode on the client to speed up transfers. If you use gftp as a client you should edit /etc/sysconfig/iptables-config on the server and add "ip_nat_ftp" into the "IPTABLES_MODULES="" directive so that it reads IPTABLES_MODULES="ip_conntrack_netbios_ns ip_conntrack_ftp ip_nat_ftp". Then reboot your machine.)</li> </ul> <div class="heading"> <a id="PHP" name="PHP"></a>PHP and Perl: </div> <ul class="list"> <li>PHP and Perl are available in Fedora Core 5 when we install the web server as described above. If you have enabled the Apache web server (see above) you can test your PHP and Perl installations by doing the following: Open the terminal. Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. Type your root password. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /var/www/html/phpinfo.php<br /></pre> </div>Hit enter and gedit will open. </li> </ul> <ul class="list"> <li>In gedit type: <div class="bordered"> <pre><?php phpinfo();?><br /></pre> </div>Click the "save" icon in gedit and close gedit. </li> </ul> <ul class="list"> <li>While still in the root terminal type: <div class="bordered"> <pre>gedit /var/www/html/printenv.pl<br /></pre> </div>Hit enter and gedit will open. </li> </ul> <ul class="list"> <li>In gedit type: <div class="bordered"> <pre>#!/usr/bin/perl<br />##<br />## printenv -- demo CGI program which just prints its environment<br />##<br /><br />print "Content-type: text/plain\n\n";<br />foreach $var (sort(keys(%ENV))) {<br /> $val = $ENV{$var};<br /> $val =~ s|\n|\\n|g;<br /> $val =~ s|"|\\"|g;<br /> print "${var}=\"${val}\"\n";<br />}<br /><br /></pre> </div>Be sure there is a blank line at the end of the file. Click the "save" icon in gedit and close gedit. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>chmod 755 /var/www/html/printenv.pl<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>chmod 755 /var/www/html/phpinfo.php<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Now when you open these files from your web server (http://whatever.com/phpinfo.php and http://whatever.com/printenv.pl) you will be able to prove the functionality of your PHP and Perl installations. (In order to allow cgi scripts to execute outside of the cgi-bin directory configure your httpd.conf as described in the web server section above.)</li> </ul> <ul class="list"> <li> <strong>Special note on configuring sendmail for PHP using your email provider's SMTP (simple mail transport protocol):</strong> <p>Your /etc/php.ini file uses sendmail as the default transport agent for sending email from PHP applications ("sendmail_path = /usr/sbin/sendmail -t -i").</p> <p>If you have not already done so edit (with gedit as we have been doing) "/etc/hosts" as root (type "su -" in a terminal, hit enter, type your root password, hit enter) and add the line "your.ip.address whatever.org whatever" where "your.ip.address" is the IP address of your web server, "whatever.org" is the registered DNS name of your web site (your canonical domain name), and "whatever" is your short domain name (the characters before the dot). Separate the IP address from the domain name with a couple of tabs.</p> <p>Edit "/etc/sysconfig/network" and change "localhost.localdomain" to "whatever.org" where "whatever.org" is the registered DNS name of your web site (your canonical domain name). Reboot.</p> <p>Edit "/etc/mail/local-host-names" and include your domain name.</p> <p>Edit "/etc/mail/sendmail.mc" and change "dnl define(`SMART_HOST',`smtp.your.provider')dnl" to "define(`SMART_HOST',`smtp.your.provider')dnl" where "smtp.your.provider" is the smtp host that you use to send mail from your email client.</p> <p>Also change "DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl" to "dnl DAEMON_OPTIONS(`Port=smtp,Addr=127.0.0.1, Name=MTA')dnl".</p> <p>Also change "dnl MASQUERADE_AS(`mydomain.com')dnl" to "MASQUERADE_AS(`your.provider.com')dnl" where "your.provider.com" is the host that you use to send mail from your email client (the characters after the "@").</p> <p>Add these lines (near the bottom of /etc/mail/sendmail.mc but above "MAILER"): "FEATURE(`genericstable',`hash -o /etc/mail/genericstable.db')dnl" and "GENERICS_DOMAIN_FILE(`/etc/mail/generics-domains')dnl".</p> <p>Edit or create if required: "/etc/mail/generics-domains". Include in "/etc/mail/generics-domains" your canonical domain name. (Be sure to add a carriage return.)</p> <p>Edit or create if required: "/etc/mail/genericstable". Include in "/etc/mail/genericstable" the line:"username mailusername@your.provider.com" where "username" is your non-root Fedora user name and "mailusername@your.provider.com" is your email address that you use with your email client. (Be sure to add a carriage return.)</p> <p>As root execute the command: "make -C /etc/mail". This will regenerate "/etc/mail/sendmail.cf".</p> <p>As root do a "yum -y install sendmail-cf".</p> <p>Reboot or start (or restart) sendmail from "System" > "Administration" > "Server Settings" > "Services".</p> <p>(See <a href="http://www.linuxhomenetworking.com/linux-hn/sendmail.htm">http://www.linuxhomenetworking.com/linux-hn/sendmail.htm</a>.)</p> </li> </ul> <div class="heading"> <a id="MySQL" name="MySQL"></a>MySQL: </div> <ul class="list"> <li>MySQL is available in Fedora Core 5. If you have not already done so go to Applications" > "Add/Remove Software", enter your root password, then under "Servers" tick the check box for "MySQL Database" and under "Optional Packages" make sure all the check boxes are ticked. Click "Close", click "Apply" and "Continue". Go to "System" > "Administration" > "Server Settings" > "Services". Type in your root password in the dialog box that appears and click on "OK". Scroll down the list and check the check box for "mysqld". Click on the "save" icon in the Service Configuration window and then close the window. Do this for runlevel 3 as well as for runlevel 5. Reboot your machine to start the MySQL service or enter the command "/sbin/service mysqld start" as root.</li> </ul> <ul class="list"> <li>Open the terminal. Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. Type your root password. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /etc/my.cnf<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>In the mysqld section of my.cnf add the line: <div class="bordered"> <pre>skip-innodb<br /></pre> </div>Your my.cnf should now look something like this: <div class="bordered"> <pre>[mysqld]<br />datadir=/var/lib/mysql<br />socket=/var/lib/mysql/mysql.sock<br /># Default to using old password format for compatibility with mysql 3.x<br /># clients (those using the mysqlclient10 compatibility package).<br />old_passwords=1<br />skip-innodb<br /><br />[mysql.server]<br />user=mysql<br />basedir=/var/lib<br /><br />[mysqld_safe]<br />err-log=/var/log/mysqld.log<br />pid-file=/var/run/mysqld/mysqld.pid<br /></pre> </div>Click the "save" icon in gedit and close gedit. </li> </ul> <ul class="list"> <li>While still in the root terminal type: <div class="bordered"> <pre>mysql -u root<br /></pre> </div>Hit enter. You will see the mysql> query prompt. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>select user, host, password, select_priv, update_priv, delete_priv, insert_priv from mysql.user;<br /></pre> </div>Hit enter. You will see something like this: <div class="bordered"> <pre>+------+------------------------+----------+-------------+-------------+-------------+-------------+<br />| user | host | password | select_priv | update_priv | delete_priv | insert_priv |<br />+------+------------------------+----------+-------------+-------------+-------------+-------------+<br />| root | localhost | | Y | Y | Y | Y |<br />| root | stantonfinley.org | | Y | Y | Y | Y |<br />| | localhost | | N | N | N | N |<br />| | stantonfinley.org | | N | N | N | N |<br />+------+------------------------+----------+-------------+-------------+-------------+-------------+<br />4 rows in set (0.17 sec)<br /><br />mysql><br /></pre> </div> </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>set password for 'root'@'localhost' = password ('newpassword');<br /></pre> </div>where "newpassword" is the password that you want to use for the root MySQL super user. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>set password for 'root'@'host' = password ('newpassword');<br /></pre> </div>where "host" is the name of your host as reported in the "host" column above and "newpassword" is the password that you want to use for the root MySQL super user. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>select user, host, password, select_priv, update_priv, delete_priv, insert_priv from mysql.user;<br /></pre> </div>Hit enter. You will see something like this with your password hash-encrypted in the "password" column: <div class="bordered"> <pre>+------+------------------------+------------------+-------------+-------------+-------------+-------------+<br />| user | host | password | select_priv | update_priv | delete_priv | insert_priv |<br />+------+------------------------+------------------+-------------+-------------+-------------+-------------+<br />| root | localhost | 1e36745e3c0f99b0 | Y | Y | Y | Y |<br />| root | stantonfinley.org | 1e36745e3c0f99b0 | Y | Y | Y | Y |<br />| | localhost | | N | N | N | N |<br />| | stantonfinley.org | | N | N | N | N |<br />+------+------------------------+------------------+-------------+-------------+-------------+-------------+<br />4 rows in set (0.00 sec)<br /><br />mysql><br /></pre> </div> </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>exit<br /></pre> </div>Close the terminal. Reboot your machine. Open a terminal. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. Type your root password. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>mysql -u root -p<br /></pre> </div>Hit enter. MySQL should ask for your MySQL super user password. Type it in. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>exit<br /></pre> </div>You have successfully set up MySQL. </li> </ul> <div class="heading"> <a id="phpMyAdmin" name="phpMyAdmin"></a>phpMyAdmin: </div> <ul class="list"> <li>Configure and enable your web server, PHP, and MySQL as described above. Open Firefox. Go to <a href="http://www.phpmyadmin.net/">http://www.phpmyadmin.net/</a> and download (save to disk) the latest stable version in bzip2 format (<a href="http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-2.8.1.tar.bz2?download">phpMyAdmin-2.8.1.tar.bz2</a>). This should save the file to your home folder. If it saves the file to your desktop instead go to your desktop and drag the file into your "Home" folder. (Left mouse click on the file and drag it on top of your "Home" folder while holding the left mouse button down. Then release the mouse button.)</li> </ul> <ul class="list"> <li>Open a terminal. Type: <div class="bordered"> <pre>su<br /></pre> </div>Hit enter. Type your root password. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>mv *.tar.bz2 /var/www/html<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>cd /var/www/html<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>bzip2 -dc *.tar.bz2 | tar -xvf -<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>rm *.tar.bz2<br /></pre> </div>Hit enter. Type "y" and hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>mv phpMyAdmin-2.8.1 phpmyadmin<br /></pre> </div>Hit enter. Close the terminal. Open the terminal again. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /var/www/html/phpmyadmin/libraries/config.default.php<br /></pre> </div>Hit enter and gedit will open. </li> </ul> <ul class="list"> <li>In /var/www/html/phpmyadmin/libraries/config.default.php change "$cfg['PmaAbsoluteUri'] = '';" to "$cfg['PmaAbsoluteUri'] = ' http://whatever.com/phpmyadmin/';" (where "whatever.com" is your web site). <p>Change "$cfg['blowfish_secret'] = ''; to "$cfg['blowfish_secret'] = 'passphrase';" where "passphrase" is some arbitrary string of characters that the blowfish algorithm will use to encrypt your password when using cookie type authentication.</p> <p>Under "Server(s) configuration" change "$cfg['Servers'][$i]['auth_type'] = 'config';" to "$cfg['Servers'][$i]['auth_type'] = 'cookie';".</p> <p>In gedit click on "File" > "Save as.." and in the "Name" box change the name of the file from "config.default.php" to "../config.inc.php". Then hit the "save" button and close gedit.</p> <p>As root do a "yum -y install php-mbstring". Close the terminal. Reboot your machine.</p> <p>Open http://whatever.com/phpmyadmin/ in Firefox (where "whatever.com" is your web site). Type "root" in the "Username:" box and your MySQL super user password in the "Password:" box. Click the "Go" button. You should see the " Welcome to phpMyAdmin" web page. Open a terminal.</p> </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>su -<br /></pre> </div>Hit enter. Type your root password. Hit enter. </li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>mysql -u root -p<br /></pre> </div>Type in your MySQL super user password. Hit enter. </li> </ul> <ul class="list"> <li>For MySQL versions 4.0.2 and above (FC5) type: <div class="bordered"> <pre>GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapassword';<br />GRANT SELECT (<br /> Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,<br /> Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,<br /> File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,<br /> Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,<br /> Execute_priv, Repl_slave_priv, Repl_client_priv<br /> ) ON mysql.user TO 'pma'@'localhost';<br />GRANT SELECT ON mysql.db TO 'pma'@'localhost';<br />GRANT SELECT ON mysql.host TO 'pma'@'localhost';<br />GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)<br /> ON mysql.tables_priv TO 'pma'@'localhost';<br />GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost';<br /><br /></pre> </div>where "pmapassword" is the password for the pma user that you select for the special "controluser" that has only the SELECT privilege on the mysql.user (all columns except "Password"), mysql.db (all columns), mysql.host (all columns) and mysql.tables_priv (all columns except "Grantor" & "Timestamp") tables. Hit enter. Hit enter. </li> </ul> <ul class="list"> <li>For MySQL versions 4.1.2 or later (FC5) open Firefox, go to http://whatever.org/phpmyadmin/scripts/create_tables_mysql_4_1_2+.sql. (Substitute your web site's registered DNS name or IP address for "whatever.org".) Click "edit" > "select all", click "edit" > "copy", go back to the terminal and click "edit" > "paste". Hit enter. The entire query should be executed at the "mysql>" prompt. If the entire query did not execute and put you back at the "mysql>" prompt carefully examine where it stopped compared to the text in "create_tables_mysql_4_1_2+.sql" and then copy the exact characters to the end of the file that need to be finished, paste them in the terminal at the location where the query stopped and hit enter again. Alternatively you could use the key combination ctrl + shift + v to paste the entire query again, overwriting the original. After you have executed this query successfully you should also copy, paste in and execute http://whatever.org/phpmyadmin/scripts/upgrade_tables_mysql_4_1_2+.sql in the same way. (Substitute your web site's registered DNS name or IP address for "whatever.org".) When the query finishes type "exit" at the mysql> prompt.</li> </ul> <ul class="list"> <li>Type: <div class="bordered"> <pre>gedit /var/www/html/phpmyadmin/config.inc.php<br /></pre> </div>Hit enter and gedit will open. </li> </ul> <ul class="list"> <li>In /var/www/html/phpmyadmin/config.inc.php change "$cfg['Servers'][$i]['controluser'] = '';" to "$cfg['Servers'][$i]['controluser'] = 'pma';". <p>Change "$cfg['Servers'][$i]['controlpass'] = '';" to "$cfg['Servers'][$i]['controlpass'] = 'pmapassword';" where "pmapassword" is the password for the pma user that you selected earlier.</p> <p>Change "$cfg['Servers'][$i]['pmadb'] = '';" to "$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';".</p> <p>Change "$cfg['Servers'][$i]['bookmarktable'] = '';" to "$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';".</p> <p>Change "$cfg['Servers'][$i]['relation'] = '';" to "$cfg['Servers'][$i]['relation'] = 'pma_relation';".</p> <p>Change "$cfg['Servers'][$i]['table_info'] = '';" to "$cfg['Servers'][$i]['table_info'] = 'pma_table_info';".</p> <p>Change "$cfg['Servers'][$i]['table_coords'] = '';" to "$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';".</p> <p>Change "$cfg['Servers'][$i]['pdf_pages'] = '';" to "$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';".</p> <p>Change "$cfg['Servers'][$i]['column_info'] = '';" to "$cfg['Servers'][$i]['column_info'] = 'pma_column_info';".</p> <p>Change "$cfg['Servers'][$i]['history'] = '';" to "$cfg['Servers'][$i]['history'] = 'pma_history';".</p> <p>Click on the "save" icon in gedit and close gedit. Close the terminal. Open Firefox and go to http://whatever.com/phpmyadmin/ where "whatever.com" is your web site registered DNS name or IP address. Log into phpMyAdmin as root. Click on the down arrow in the "Database:" selection dialog box in the left column. You should see the "mysql", "phpmyadmin", and "test" databases listed. You may delete ("drop") the "test" database if you wish. You have now successfully configured phpMyAdmin.</p> </li> </ul> <div class="heading"> <a id="Resources" name="Resources"></a>Resources: </div><div class="blogger-post-footer"><img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/11430866-114960788875933502?l=microdatainc.blogspot.com' alt='' /></div>microdatainchttp://www.blogger.com/profile/05909916944497316292noreply@blogger.com3