Install and Configure Apache Server on CentOS Apache Server Apache HTTP Server is an open-source HTTP server for modern ....
Read more here ...
Read more here ...
Showing posts with label Install. Show all posts
Showing posts with label Install. Show all posts
Monday, 4 June 2012
Thursday, 24 May 2012
Install and Configure MySQL on CentOS
MySQL is the world's most popular open source database.
MySQL Community Edition is freely downloadable version.
Commercial customers have the flexibility of choosing from multiple editions to meet specific business and technical requirements. For more details please refer to the MySQL official website.
INSTALL :
On any CentOS server with open internet, run the below command to install MySQL Community Edition:
OR
Download the server and client rpm files from the MySQL Website depending upon the platform(OS) and architecture(32/64bit).
Install both rpm files using below command:
Example:
CONFIGURE :
Once installed, run the below commands to configure MySQL Server:
1.Set the MySQL service to start on boot
2. Start the MySQL service
3. By default the root user will have no password, so to log into MySQL use command:
4. To exit Mysql Console, enter below command
SET PASSWORD FOR ROOT :
To set the root user password for all local domains, login and run below commands
(Replace <<new-password>> with actual password)
OR
run below command at linux shell:
(Replace <<new-password>> with actual password)
Once password is set, to login to Mysql use below command:
Once you enter the above command, you will be prompted for the root password.
To add a new user for MySQL login, use the below SQL query. Remember this query must be run from the MySQL prompt.
for localhost:
for anyhostname:
Replace <<USERNAME>> and <<PASSWORD>> with actual username and password respectively.
Note they must be enclosed in single quotes.
DROP ANY USER :
In case, you want to drop any user use below command:
(Replace <<username>> with actual username)
For more help and commands, refer --> http://www.yolinux.com/TUTORIALS/LinuxTutorialMySQL.html
MySQL Community Edition is freely downloadable version.
Commercial customers have the flexibility of choosing from multiple editions to meet specific business and technical requirements. For more details please refer to the MySQL official website.
INSTALL :
On any CentOS server with open internet, run the below command to install MySQL Community Edition:
yum install mysql-server mysql php-mysqlOR
Download the server and client rpm files from the MySQL Website depending upon the platform(OS) and architecture(32/64bit).
Install both rpm files using below command:
rpm -ivh <<rpm_filenames>>Example:
rpm -ivh mysql-server-version.rpm mysqlclient9-version.rpm
CONFIGURE :
Once installed, run the below commands to configure MySQL Server:
1.Set the MySQL service to start on boot
chkconfig --levels 235 mysqld onservice mysqld startmysql -u root4. To exit Mysql Console, enter below command
exit;
SET PASSWORD FOR ROOT :
To set the root user password for all local domains, login and run below commands
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('<<new-password>>');SET PASSWORD FOR 'root'@'localhost.localdomain' = PASSWORD('<<new-password>>');SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('<<new-password>>');(Replace <<new-password>> with actual password)
OR
run below command at linux shell:
mysqladmin -u root password '<<new-password>>'Once password is set, to login to Mysql use below command:
mysql -u root -pOnce you enter the above command, you will be prompted for the root password.
ADD NEW USER :
To add a new user for MySQL login, use the below SQL query. Remember this query must be run from the MySQL prompt.
for localhost:
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) VALUES ('localhost', '<<USERNAME>>', password('<<PASSWORD>>'), 'Y','Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', '', '', '', '', 0, 0, 0, 0);for anyhostname:
INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, max_questions, max_updates, max_connections, max_user_connections) VALUES ('%', '<<USERNAME>>', password('<<PASSWORD>>'), 'Y','Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', '', '', '', '', 0, 0, 0, 0);Replace <<USERNAME>> and <<PASSWORD>> with actual username and password respectively.
Note they must be enclosed in single quotes.
DROP ANY USER :
In case, you want to drop any user use below command:
DROP '<<username>>''@'localhost';DROP '<<username>>''@'localhost.localdomain';(Replace <<username>> with actual username)
For more help and commands, refer --> http://www.yolinux.com/TUTORIALS/LinuxTutorialMySQL.html
Friday, 18 May 2012
Install JAVA on Linux using rpm files
Steps for installing JAVA (JDK 6) on linux using rpm files:
1. Log into the linux shell and become root user by running the command
2. Change directory.
3. Please search at http://www.oracle.com/technetwork/java/javase/downloads/index.html for newer versions to download.
You can download to any directory you choose; it does not have to be the directory where you want to install the JDK. Before you download the file, notice its byte size provided on the download page on the web site. Once the download has completed, compare that file size to the size of the downloaded file to make sure they are equal.
To download use one of the below commands, depending on the server's architecture (32/64 bit) :
64 bit:
32 bit:
4. Make sure that execute permissions are set in the self-extracting binary.
Enter
5. Run below command to grant execute permission to the file:
For e.g.:
6. Change directory to the location where you would like the files to be installed. The next step installs the JDK into the current directory.
7. Execute the downloaded file, prepended by the path to it.
For example, if the file is in the current directory, prepend it with "./" :
For e.g.:
8. The binary code license is displayed, and you are prompted to agree to its terms.
9. Check if java is installed using command
The java version must be displayed correctly. You may also want to run commands like
10. Execute below command to test if the JAVA_HOME environment variable is set.
It must display the location where java is installed.
11. Delete the bin and rpm files if you want to save disk space.
1. Log into the linux shell and become root user by running the command
su –i2. Change directory.
cd /opt3. Please search at http://www.oracle.com/technetwork/java/javase/downloads/index.html for newer versions to download.
You can download to any directory you choose; it does not have to be the directory where you want to install the JDK. Before you download the file, notice its byte size provided on the download page on the web site. Once the download has completed, compare that file size to the size of the downloaded file to make sure they are equal.
To download use one of the below commands, depending on the server's architecture (32/64 bit) :
64 bit:
wget http://download.oracle.com/otn-pub/java/jdk/6u31-b04/jdk-6u31-linux-x64-rpm.bin32 bit:
wget http://download.oracle.com/otn-pub/java/jdk/6u31-b04/jdk-6u31-linux-i586-rpm.bin
4. Make sure that execute permissions are set in the self-extracting binary.
Enter
ls –la to see the permissions for the file.
5. Run below command to grant execute permission to the file:
chmod a+x <<name-of-rpm-file-downloaded-earlier>>For e.g.:
chmod +x jdk-6u25-linux-x64-rpm.bin\?e\=1306317438\&h\=294de0d36f54e28dd65fc8370e3c406d6. Change directory to the location where you would like the files to be installed. The next step installs the JDK into the current directory.
7. Execute the downloaded file, prepended by the path to it.
For example, if the file is in the current directory, prepend it with "./" :
./<<name-of-rpm-file-downloaded-earlier>>For e.g.:
./jdk-6u25-linux-x64-rpm.bin\?e\=1306317438\&h\=294de0d36f54e28dd65fc8370e3c406d
8. The binary code license is displayed, and you are prompted to agree to its terms.
9. Check if java is installed using command
java -version
The java version must be displayed correctly. You may also want to run commands like
java or javac to check if installation is proper.10. Execute below command to test if the JAVA_HOME environment variable is set.
echo $JAVA_HOMEIt must display the location where java is installed.
11. Delete the bin and rpm files if you want to save disk space.
rm -rf sun*
Subscribe to:
Posts (Atom)