my.cnf includedir not working as expected
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.0 (Ubuntu) |
Fix Released
|
Wishlist
|
Unassigned | ||
Bug Description
The last lines in /etc/mysql/my.cnf (Gutsy) says
#
# * IMPORTANT: Additional settings that can override those from this file!
#
!includedir /etc/mysql/conf.d/
I want MySQL running with UTF-8, hence:
1/
# printf "[mysqld]
2/
# /etc/init.d/mysql restart
* Stopping MySQL database server mysqld
...done.
* Starting MySQL database server mysqld
...done.
* Checking for corrupt, not cleanly closed and upgrade needing tables.
3/
# mysql -uroot -Bse 'SHOW VARIABLES LIKE "char%"'
character_
character_
character_
character_
character_
character_
character_
character_sets_dir /usr/share/
4/
Didn't work, character_
What works is the following:
1/
Edit /etc/mysql/my.cnf and add this right below [mysqld]
character-
default-
2/
# /etc/init.d/mysql restart
* Stopping MySQL database server mysqld
...done.
* Starting MySQL database server mysqld
...done.
* Checking for corrupt, not cleanly closed and upgrade needing tables.
3/
# mysql -uroot -Bse 'SHOW VARIABLES LIKE "char%"'
character_
character_
character_
character_
character_
character_
character_
character_sets_dir /usr/share/
More info:
# dpkg -l |grep mysql
ii libdbd-mysql-perl 4.004-2 A Perl5 database interface to the MySQL data
ii libmysqlclient15off 5.0.45-1ubuntu2 MySQL database client library
ii mysql-client-5.0 5.0.45-1ubuntu2 MySQL database client binaries
ii mysql-common 5.0.45-1ubuntu2 MySQL database common files
ii mysql-server-5.0 5.0.45-1ubuntu2 MySQL database server binaries
ii php5-mysql 5.2.3-1ubuntu4 MySQL module for php5
Related branches
Changed in mysql-dfsg-5.0: | |
importance: | Undecided → Wishlist |
status: | Confirmed → Triaged |
Changed in mysql-dfsg-5.0: | |
status: | Triaged → In Progress |
Thank you for taking the time to report this bug and helping to make Ubuntu better. This bug did not have a package associated with it, which is important for ensuring that it gets looked at by the proper developers. You can learn more about finding the right package at [WWW] https:/ /wiki.ubuntu. com/Bugs/ FindRightPackag e. I have classified this bug as a bug in mysql-dfsg-5.0