List:General Discussion« Previous MessageNext Message »
From:Peter Boros Date:June 1 2011 10:34am
Subject:Re: Not finding my.cnf file
View as plain text  
Hi,

You probably didn't run mysql_install_db.

Peter Boros

On Wed, 2011-06-01 at 15:52 +0530, Adarsh Sharma wrote:
> I got the error after setting my.cnf file in /etc directory.
> 
> 110601 15:23:02 [Note] Plugin 'FEDERATED' is disabled.
> /usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
> 
> After some research i found the cause of this error : the new my.cnf
> is very old and mysql_upgrade is needed
> 
> So , Can someone Please give my a standard my.cnf file that contains
> all the parameters.
> 
> Is my.cnf file is different for different versions.
> My mysql version is 5.1.4. Please check my attached my.cnf file
> 
> Thanks
> 
> John Daisley wrote: 
> > I think the default location on Centos is /etc/my.cnf
> > 
> > Regards
> > John
> > 
> > On 1 June 2011 10:24, Adarsh Sharma <adarsh.sharma@stripped> wrote:
> > 
> >   
> > > Dear all,
> > > 
> > > I install mysql in CentOS -5.4 through 2 commands :
> > > 
> > > yum install mysql-server
> > > yum install mysql-client
> > > 
> > > And I can see directories created in /var/lib/mysql directory.
> > > 
> > > But now i want to change it to my /hdd1-1 diretcory and alse set logging
> > > directories.
> > > So , I search my.cnf file as:
> > > 
> > > [root@ws-test ~]# find / -name my.cnf
> > > [root@ws-test ~]#
> > > 
> > > Now how could I solve this issue & from where mysql picks its
> configuration
> > > or it go for its default.
> > > 
> > > 
> > > Thanks & best Regards,
> > > Adarsh Sharma
> > > 
> > > --
> > > MySQL General Mailing List
> > > For list archives: http://lists.mysql.com/mysql
> > > To unsubscribe:
> > > http://lists.mysql.com/mysql?unsub=1
> > > 
> > > 
> > >     
> > 
> > 
> >   
> 
> plain text document attachment (my.cnf)
> #This is for a large system with memory = 512M where the system runs mainly
> # MySQL.
> #
> # You can copy this file to
> # /etc/my.cnf to set global options,
> # mysql-data-dir/my.cnf to set server-specific options (in this
> # installation this directory is @localstatedir@) or
> # ~/.my.cnf to set user-specific options.
> #
> # In this file, you can use all long options that a program supports.
> # If you want to know which options a program supports, run the program
> # with the "--help" option.
> 
> # The following options will be passed to all MySQL clients
> 
> [client]
> #password = your_password
> port  = 3306
> socket  = /var/lib/mysql/mysql.sock
> 
> # Here follows entries for some specific programs
> # The MySQL server
> [mysqld]
> port  = 3306
> socket  = /var/lib/mysql/mysql.sock
> #skip-locking
> 
> # Caches and Buffer Sizes
> key_buffer = 256M
> max_allowed_packet=16M
> table_cache = 256
> sort_buffer_size = 2M
> read_buffer_size = 2M
> read_rnd_buffer_size = 4M
> 
> #record_buffer = 1M
> 
> myisam_sort_buffer_size = 128M
> thread_cache = 128
> query_cache_limit = 2M
> query_cache_type = 1
> query_cache_size = 32M
> key_buffer = 16M
> join_buffer = 2M
> table_cache = 1024
> 
> datadir = /hdd2-1/myisam_data
> 
> log-bin=mysql-bin
> 
> #Time Outs
> interactive_timeout = 100
> wait_timeout = 100
> connect_timeout = 10
> 
> # Try number of CPU's*2 for thread_concurrency
> thread_concurrency = 2
> 
> # Maximum connections allowed
> max_connections = 100
> max_user_connections = 50
> max_connect_errors = 10
> 
> # Don't listen on a TCP/IP port at all. This can be a security enhancement,
> # if all processes that need to connect to mysqld run on the same host.
> # All interaction with mysqld must be made via Unix sockets or named pipes.
> # Note that using this option without enabling named pipes on Windows
> # (via the "enable-named-pipe" option) will render mysqld useless!
> #
> #skip-networking
> 
> # Replication Master Server (default)
> # binary logging is required for replication
> 
> # required unique id between 1 and 2^32 - 1
> # defaults to 1 if master-host is not set
> # but will not function as a master if omitted
> server-id = 1
> 
> # Replication Slave (comment out master section to use this)
> #
> # To configure this host as a replication slave, you can choose between
> # two methods :
> #
> # 1) Use the CHANGE MASTER TO command (fully described in our manual) -
> #    the syntax is:
> #
> #    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
> #    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
> #
> #    where you replace <host>, <user>, <password> by quoted strings
> and
> #    <port> by the master's port number (3306 by default).
> #
> #    Example:
> #
> #    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
> #    MASTER_USER='joe', MASTER_PASSWORD='secret';
> #
> # OR
> #
> # 2) Set the variables below. However, in case you choose this method, then
> #    start replication for the first time (even unsuccessfully, for example
> #    if you mistyped the password in master-password and the slave fails to
> #    connect), the slave will create a master.info file, and any later
> #    change in this file to the variables' values below will be ignored and
> #    overridden by the content of the master.info file, unless you shutdown
> #    the slave server, delete master.info and restart the slaver server.
> #    For that reason, you may want to leave the lines below untouched
> #    (commented) and instead use CHANGE MASTER TO (see above)
> #
> # required unique id between 2 and 2^32 - 1
> # (and different from the master)
> # defaults to 2 if master-host is set
> # but will not function as a slave if omitted
> #server-id      = 2
> #
> # The replication master for this slave - required
> #master-host    =  <hostname>
> #
> # The username the slave will use for authentication when connecting
> # to the master - required
> #master-user    =  <username>
> #
> # The password the slave will authenticate with when connecting to
> # the master - required
> #master-password =  <password>
> #
> # The port the master is listening on.
> # optional - defaults to 3306
> #master-port    =  <port>
> #
> # binary logging - not required for slaves, but recommended
> #log-bin
> 
> # Point the following paths to different dedicated disks
> #tmpdir  = /tmp/ 
> #log-update  = /path-to-dedicated-directory/hostname
> 
> # Uncomment the following if you are using BDB tables
> #bdb_cache_size = 64M
> #bdb_max_lock = 100000
> 
> # Uncomment the following if you are using InnoDB tables
> innodb_data_home_dir = /var/lib/mysql/
> innodb_data_file_path = ibdata1:10M:autoextend
> innodb_log_group_home_dir = /var/log/innodblogs/
> #innodb_log_arch_dir = /var/log/innodblogsarchive/
> 
> # You can set .._buffer_pool_size up to 50 - 80 %
> # of RAM but beware of setting memory usage too high
> innodb_buffer_pool_size = 4096M
> innodb_additional_mem_pool_size = 20M
> # Set .._log_file_size to 25 % of buffer pool size
> innodb_log_file_size = 40M
> innodb_log_buffer_size = 8M
> innodb_flush_log_at_trx_commit = 1
> innodb_lock_wait_timeout = 50
> 
> [mysqldump]
> quick
> max_allowed_packet = 16M
> 
> [safe_mysqld]
> err-log=/var/log/mysqld.log
> pid-file=/var/lib/mysql/mysql.pid <-- Not necessary
> open_files_limit=8192
> 
> 
> [mysql]
> no-auto-rehash
> # Remove the next comment character if you are not familiar with SQL
> #safe-updates
> 
> [isamchk]
> key_buffer = 128M
> sort_buffer_size = 128M
> read_buffer = 2M
> write_buffer = 2M
> 
> [myisamchk]
> key_buffer = 128M
> sort_buffer_size = 128M
> read_buffer = 2M
> write_buffer = 2M
> 
> [mysqlhotcopy]
> interactive-timeout/log
> #-----------------------------------------
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Thread
Not finding my.cnf fileAdarsh Sharma1 Jun
  • Re: Not finding my.cnf fileAndrew Moore1 Jun
  • Re: Not finding my.cnf fileJohn Daisley1 Jun
    • Re: Not finding my.cnf fileAdarsh Sharma1 Jun
      • Re: Not finding my.cnf filePeter Boros1 Jun
        • Re: Not finding my.cnf fileAdarsh Sharma1 Jun
          • Re: Not finding my.cnf fileAndrew Moore1 Jun