How to install MySQL 5.1 on Ubuntu 10.10

Its easy to install MySQL on ubuntu but you must have updated your repository for apt-get utility. If you haven’t than run below command to update it. shell> apt-get update After that, to install MySQL 5.1 on ubuntu run below command. shell>sudo apt-get install mysql-server-5.1 you’ll have to give your password so it will start…

How to enable compositing in ubuntu 10.10

Some time after installing of ubuntu, we are getting errors with visual effects/any dock tools like docky or AWN/ubuntu themes. i.e “You need to unable Desktop Effects (Compositer) to apply and customise themes. Following are the simple steps to get rid out of that error. Press Alt-F2 to open the “Run Application” box / Open…

How to monitor performance of MySQL Server

Performance Monitoring of MySQL Server: Following are the command which we can use for session or server level performance for MySQL server. SHOW GLOBAL STATUS – shows global server status SHOW LOCAL STATUS  – This is used for session level server status Have to check following values to know how server works. Aborted_clients : Usually…

How to unlock huawei comet U8150

This is the best site to unlock the huawei comet U8150 phone. I have tried it, follow all the steps and finally my phone is unlocked and I’m using different service provider on the same phone. http://www.dc-unlocker.com/huawei_u8150_detect_and_unlock_procedure  

MySQL DBA Responsibilities

Overview of DBA duties Server startup/shutdown Mastering the mysqladmin administrative client Using the mysql interactive client User account maintenance Log file maintenance Database backup/copying Hardware tuning Multiple server setups Software updates and upgrades File system security Server security Repair and maintenance Crash recovery Preventive maintenance Understanding the mysqld server daemon Performance analysis Obtaining and Installing…

How to reset MySQL root password

1. Stop mysql service shell> /etc/init.d/mysql stop 2. Start to MySQL server without password. shell> mysqld_safe –skip-grant-tables & 3. Connect to mysql server using mysql client. shell> mysql -u root Welcome to the MySQL monitor.  Commands end with ; or g.Your MySQL connection id is 107Server version: 5.1.49-1ubuntu8.1 (Ubuntu)Type ‘help;’ or ‘h’ for help. Type…

How to secure MySQL server

OS level Security: Never run the MySQL server as the linux ‘root’ user. Always create the separate user for MySQL and start/stop MySQL server with it. If the data directories are located under $mysql_home/data dir then make sure that directory and all subdirectories should have only read and write privileges for the mysql user. Always…