Hi, in this tutorial I’ll show to you how easy is to setup a LAMP web server with Mandriva Linux, just pay attention and do the steps carefully.
To make things crystal clear all the commands you have to use are in italic and the steps in bold.
Everything will be done using the root account, so open up a terminal and login as root.
Logging as system administrator
Type your root password.
First of all, you will download the apache web server, apache php module, MySQL Daemon and a tool to administrate you database, called PHPMyAdmin.
Installing all packages
# urpmi apache-mpm-prefork apache-mod_php mysql phpmyadmin –auto
If everything went right you have just downloaded and installed everything you need, if something went wrong or you have any question in this step, just ask in a comment!
In the following you are going to start the MySQL Daemon and then setup a password for the MySQL root user. This user and password you will user everything you login on the PHPMyAdmin panel to configure and administrate your databases.
Starting the MySQL Daemon
# /etc/init.d/mysqld restart
Creating a password for the MySQL root user
# /usr/bin/mysqladmin -u root password YOUR_NEW_PASSWORD
Ok, at this moment you are able to use and connect to your very own MySQL server!
Again, any error or question, just ask!
Now you will start the Apache Web Server and create a new MySQL user and database, using the phpmyadmin tool, it is really easy.
Starting up the apache web server
# /etc/init.d/httpd restart
You might get an error message here related to your hostname, you need to have a “qualified” host name, as “myserver” or “johnpc” or whatever but “localhost”. If you hostname is “localhost”, you have to change it, to do so, you can either use the drakconnect tool or drakhost. Any question, ask.
You are almost there, in the following you will finally create a new user and a new database.
Opening the phpmyadmin page
Open your browser and go to http://127.0.0.1/phpmyadmin
Go to “Privileges” Tab
Click on “Add a new User”
In “User name:” Put the username you want to use for you service/database, your database name will have the same name.
Write a new password at “Password:” and retype it. I can be the same password as above.
Now, in “Database for user” choose “Create database with same name and grant all privileges”.
And finally at “Global privileges” click on “Check all” and then on the button “Go”.
Ok, at this point you have both Apache and MySQL up and running.
The database address you will use in you website, wordpress, media wiki or whatever will be localhost.
The username you created above is the username you will put on the username box.
Password on the password box and database name on the database box, did you get it?
Questions? Suggestions? Comment!