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.sha...@orkash.com> 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=john.dais...@butterflysystems.co.uk > > > > > > > > > > > > > > > > > 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=pe...@petya.org.hu -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
