To repair a corrupted MySQL database table, simply do the following steps:
a) Login to your MySQL server using Secure Shell (SSH).
b) Enter the following command at root prompt:
mysqlcheck -r [database name]
How to Reset MySQL root Password
To reset your MySQL root password, please follow these steps:
1)root@server [~] /etc/init.d/mysqld stop
2) Start MySQL server without password:
root@server [~] mysqld_safe –skip-grant-tables &
3) root@server [~] mysql Read More
How to resolve the error ‘Table ‘mysql.servers’ doesn’t exist”
After plesk upgrade or with newly installed plesk , if you are not able to set the passwords for the
new database users or not able to do any kind of activity with the database users and mysql error log shows
[ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist
Then here are steps which could be referred:
Testing a MySQL Cluster
Testing the Cluster
To perform a test on our new MySQL Cluster, we have to login to the SQL Nodes db4 or db5 servers.
Login to the db4 server:
ssh root@192.168.1.123
How to Install and Configure MySQL Cluster
To implement a MySQL Cluster, we have to install three types of nodes. Each node type will be installed on it’s own server. The components are:
1. Management Node – NDB_MGMD/MGM
The Cluster management server is used to manage the other node of the cluster. We can create and configure new nodes, restart, delete, or backup nodes on the cluster from the management node.
How to change mysql default port in Linux
To change the MySQL Server default port no. 3306,follow the given below steps.
1. Check the aviailbe port in system first:
# netstat -tanp |grep xxxx
How to import a sql file into mySQL in linux
Login as root, typing the command below.
#mysql databasename -u databaseuser -p databasepassword < database.sql
How to using Mytop to monitoring MySQL
To install Mytop, run the following command. Make sure you must have RPMForge or EPEL repository under RHEL/CentOS systems.
# yum install mytop
Creating A MySQL Table
Before you can do anything with your database, you must create a table. A table is a section of the database for storing related information. In a table you will set up the different fields which will be used in that table. Because of this construction, nearly all of a site’s database needs can be satisfied using just one database.
MySQL Delete with PHP
Delete Data In a Database
The DELETE FROM statement is used to delete records from a database table.
