Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 121 to 130 of 33574 10 Older Entries
Got a packet bigger than 'max_allowed_packet' bytes
+0 Vote Up -1Vote Down

mysql> show slave status\G

*************************** 1. row ***************************

               Slave_IO_State:

                  Master_Host: mk-mysqlcluster-2-miscdb-rw.uk.intranet

                  Master_User: replusr_miscdb

                  Master_Port: 3306

…  [Read more...]
MySQL Privilege management for Stored Procedures and Functions
+0 Vote Up -0Vote Down

Execute permission for a Procedure or Function can be granted to Individually as shown below:

 

GRANT EXECUTE ON PROCEDURE `eonline`.`sp_getmailjoblist` TO 'eonline_rw'@'%' ;                            

GRANT EXECUTE ON FUNCTION `eonline`.`fn_getmailjobsub` TO 'eonline_rw'@'%' ;     

 

To Grant execute permission on all Procedures and Functions of a particular database say 'eonline' to a particular user say 'eonline_rw'  in …

  [Read more...]
Securing MySQL Database – removal of anonymous accounts
+0 Vote Up -0Vote Down

Anonymous MySQL accounts allow clients to connect to the server without specifying a user name. To remove anonymous accounts, connect to the server as the MySQL root user to access the mysql database, then issue the following statements:

 

mysql> select user,host FROM user WHERE User = '';

+------+----------------------+

| user | host                 |

+------+----------------------+

|      | localhost            |

  [Read more...]
Install InnoDB Plugin for mysql 5.1
+0 Vote Up -1Vote Down

You can read about it here.  "

 

  • The InnoDB Plugin offers new features, improved performance and scalability, enhanced reliability and new capabilities for flexibility and ease of use. Among the features of the InnoDB Plugin are "Fast index creation," table and index compression, file format management, new INFORMATION_SCHEMA tables, capacity tuning, multiple background I/O threads, and group commit.

For information about these features, see …

  [Read more...]
Install MYSQL on SOLARIS
+0 Vote Up -0Vote Down
  1. Download the correct version.  There are two versions – a tar file and a package.  The package version installs as part of the Solaris OS , but then means we can have no further mysql installs.  So we tend to download the tar version e.g. mysql-advanced-gpl-5.1.47-solaris10-x86_64.tar

 

  1. Put the download into the bin directory eg /ebilldb-master/mysql-bin

 

  1. untar the download file, this creates a directory called mysql-advanced-gpl-5.1.47-solaris10-x86_64

 

  1. change permissions i.e.

 

chown -R …

  [Read more...]
Failed to initialize the master info structure
+0 Vote Up -0Vote Down

ERROR:

 

091104 11:12:49 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.9339843' (relay_log_pos 233)

091104 11:12:49 [ERROR] Could not find target log during relay log initialization

091104 11:12:49 [ERROR] Failed to initialize the master info structure

 

 

 

Due to the way in which the master and slaves where stopped  the relay logs got out of sync, hence replication would not restart.

 

Found the solution was to

 

a) make a note of Master_Log_File and …

  [Read more...]
Reset Auto Increment for a Table - ERROR 1062 (23000): Duplicate entry '2147483647' for key 1
+0 Vote Up -0Vote Down

PROVSERVICE table on VMS ANYPROV has a column which is auto increment

 

+---------------------+--------------+------+-----+---------------------+----------------+

| Field               | Type         | Null | Key | Default             | Extra          |

+---------------------+--------------+------+-----+---------------------+----------------+

| …

  [Read more...]
‘mysqld got signal 11’
+0 Vote Up -0Vote Down

 

It is not clear what caused this, but this is how it was fixed – eventually!  The main issue that resulted from the failure was that the database would not restart and there were 1000's of relay log files in the $DATADIR

 

  • Killed all mysql processes and mysqld processes – had to use kill -9 for mysqld process

 

  • Removed all relay bin logs from $DATADIR

 

  • Restarted mysql using /usr/local/mysql/bin/mysqld_safe &

 

  • Stopped slave

 

  • Systems team stop mail …
  [Read more...]
Uninstalling Mysql on FreeBSD
+0 Vote Up -0Vote Down

pkg_delete -x mysql

Resetting root password when locked out of mysql
+0 Vote Up -1Vote Down

http://dev.mysql.com/doc/refman/5.1/en/resetting-permissions.html#resetting-permissions-unix

10 Newer Entries Showing entries 121 to 130 of 33574 10 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.