Install mysql enterprise database on Enterprise Linux

Installed the mysql using oracle e-delivery package

shell> unzip -t V33087-01.zip
Archive:  V33087-01.zip
    testing: MySQL-devel-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: MySQL-test-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: MySQL-embedded-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: MySQL-client-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: MySQL-shared-compat-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: MySQL-shared-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: MySQL-server-advanced-5.5.25-1.rhel5.x86_64.rpm   OK
    testing: README.txt               OK
No errors detected in compressed data of V33087-01.zip.

shell> rpm -ivh MySQL-server-advanced-5.5.25-1.rhel5.x86_64.rpm
OK

shell> rpm -ivh  MySQL-client-advanced-5.5.25-1.rhel5.x86_64.rpm
OK

shell>  /etc/init.d/mysql start
OK

shell> mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

SOLUTION
=========

shell>  /etc/init.d/mysql stop
OK

shell>  /etc/init.d/mysql start --skip-grant-tables
OK

shell> mysql -u root mysql

mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> exit


shell>  /etc/init.d/mysql restart --skip-grant-tables

OK

shell> mysql -u root -p
Enter password: your_new_password

mysql> yeppyyy!!!

P.S - For production environment it is advisable to drop sample schemas and Anonymous user
        to accomplish this run the command
        /usr/bin/mysql_secure_installation

:)






Comments

Post a Comment

Leave a message

Popular posts from this blog

Installation of MySQL Enterprise Monitor Agent on Linux

If you are new reader, kindly note that this post contains it's first part on post   "Installation of MySQL Enterprise Server Manager" . As the second step as mySQL monitor installation we need to install the monitoring agent for each instance. So in order to accomplish that we first need to create a user and grant relevent permission to that user. Create agent user on mySQL mysql> CREATE USER 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';   mysql> GRANT SELECT, REPLICATION CLIENT, SHOW DATABASES, SUPER, PROCESS  ON *.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';  mysql> GRANT CREATE, INSERT ON mysql.* TO 'mysqlagnt'@'localhost' IDENTIFIED BY 'agentpass';     mysql> GRANT SELECT ON mysql.inventory TO 'replicationuser'@'%' IDENTIFIED BY 'replication_password'; NOTE : SET SQL_LOG_BIN=0 to stop replicating the below ...
Read more

Installation and Configuration of Cisco VPN Client on Linux

Installation of Cisco VPN client on Linux is something quiet easy. You just need to download the installation file. Extract it using shell>> tar zxvf vpnclient-linux-x86_64-4.8.01.0640-k9.tar.gz Move inside the vpnclient folder created after extracting the tarball using shell>> cd vpnclient Run the executable file vpn_install using shell>> ./vpn_install Provide necessary locations or confirm the defaults. Start the service using shell>> /etc/init.d/vpnclient_init start Copy the configuration file ( *.pcf ) or edit the existing sample.pcf file accordingly in the path of the profile folder. E.g : mine is /etc/CiscoSystemsVPNClient/profiles/sample.pcf After changing the or placing the new configuration file restart the vpn client using shell>> /etc/init.d/vpnclient_init restart And connect to the vpn using shell>> vpnclient connect sample ( if you have provide another name instead of sample to the .pcf file use that name...
Read more

Oracle Startup Issues ORA-16038

Image
ORA-16038: log 1 sequence# 244 cannot be archived  ORA-19809: limit exceeded for recovery files  ORA-00312: online log 1 thread 1  There is a possibility to encounter this issue in oracle database and when this happens you wont be able to open the database. you will be getting this once the  db_recovery_file_dest_size   value  gets exceeded.  However you can fix this one by increasing the  db_recovery_file_dest_size   or by clearing the  obsolete files. To increase the  db_recovery_file_dest_size   size use the following steps. 
Read more