There are two ways to reset MySQL root password as follows:
FIRST WAY

Stop the server
Open a text file, give the below statement and save the file (for example the filename is /tmp/newpass.txt).

UPDATE mysql.user SET Password=PASSWORD(’YourNewPassword’) WHERE User=’root’ and host=’localhost’;
FLUSH PRIVILEGES;

Now, start the server with –init-file option

mysqld_safe –init-file=/tmp/newpass.txt &

You [...]

When I tried to connect mysqld server, I got this error.
ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’
1. Check whether mysqld server is running or not, using the below command
ps -ef | grep mysql
If mysqld is running, then check the socket path in the .cnf file and give the correct path [...]

I ran a explain plan in MySQL and i got
mysql> explain SELECT users.user_id FROM friends INNER JOIN users ON friends.friend_to = users.user_id WHERE friends.friend_from=108643 and friends.friend_to=108643;
+—-+————-+——-+——+—————+——+———+——+——+—————————————————–+
| id | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra                      [...]

I started MySQL server like this,
/usr/local/src/mysql-5.1.42-linux-x86_64-glibc23/bin/mysqld_safe  –datadir=/usr/local/src/mysql-5.1.42-linux-x86_64-glibc23/data –basedir=/usr/local/mysql-5.1.42-linux-x86_64-glibc23 &
I got the error shown below
mysqld_safe The file /usr/local/mysql/bin/mysqld does not exist or is not executable.
and I fixed by entering in to MySQL installed directory and started the server
cd /usr/local/src/mysql-5.1.42-linux-x86_64-glibc23
./bin/mysqld_safe  –datadir=/usr/local/src/mysql-5.1.42-linux-x86_64-glibc23/data –basedir=/usr/local/mysql-5.1.42-linux-x86_64-glibc23 &

Hi,
MySQL Cluster executes the queries depending on the below type of scan’s it does

Primary key lookup
Unique key lookup
Ordered index scan (i.e., non-unique indexes that use T-trees)
Full table scan

Let’s say you have 4 data nodes in your cluster (NoOfReplicas=2). This means you have 2 node groups and each one has half the data. Cluster uses a [...]

Hi,
When we take a mysqldump with routines or show procedure status where Db=’dbname’;
The mysqld server got an error like “Lost connection to mysqld server”, when we login into server the will be running and it got restarted.
To fix this, upgrade the db by using mysql_upgrade and it got fixed for me.
Thanks,
Suresh Kuna

This type of error may occur in the below scenarios.
1) It indicates network connectivity trouble. If the error message includes “during query” then we have to look at the query and the number of rows being sent.
Then try increasing “net_read_timeout” variable from its default value.
2) It can happen when the client is attempting the initial [...]

Hi,
If the Mysql is not starting and the error log consists of the below error after the configuration of a slave with the tar file of master.
081022 6:19:02 InnoDB: Warning: shutting down a not properly started
InnoDB: or created database!
081022 6:19:02 /usr/local/mysql4020/libexec/mysqld: Shutdown Complete
InnoDB: Error: data file /mysql/data/mysqld/ibdata1 is of a different size
InnoDB: 128000 pages (rounded [...]

Hi Team,
The slave server is getting this error in error log.
081102  0:30:18 [Note] Slave: connected to master ‘replicate@10.0.1.5:3310′,replication resumed in log ‘central3310.000142′ at position 789529654
081102  0:30:18 [Note] Slave: received end packet from server, apparent master shutdown:
081102  0:30:18 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log ‘central3310.000142′ position 789529654
Solution :
The problem has [...]

HI,
Error Message :
/usr/local/mysql/bin/mysqldump: Can’t get CREATE TABLE for table `Tory_Map` (Can’t open file: ‘Tory_Map.MYI’. (errno: 145))
Solution :
1) Do a show table status as below:
mysql> show table status like ‘Tory_Map’\G
*************************** 1. row ***************************
Name: Tory_Map
Type: NULL
Row_format: NULL
Rows: NULL
Avg_row_length: NULL
Data_length: NULL
Max_data_length: NULL
Index_length: NULL
Data_free: NULL
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Create_options: NULL
Comment: Can’t open file: ‘Tory_Map.MYI’. (errno: 145)
1 row in [...]