Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Mon Jan 04, 2016 12:45 pm 
Offline
Newbie

Joined: Wed Dec 30, 2015 11:48 am
Posts: 3
My linode is Ubuntu 15.10 linode 1024.
I have very limited knowledge about setting up LAMP environment, so I could only blindly follow the https://www.linode.com/docs/websites/hosting-a-website. I just finished step 5 in "Optimizing MySQL for a Linode 1GB". When I tried to proceed to the next step and start mysql to create database, I got this error message:"unknown variable 'max_connections=75'".

Here is the content of my "my.cnf":

Code:
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
#### Added by me #####
[mysql]
max_connections = 75
max_allowed_packet = 1M
thread_stack = 128K
table_open_cache = 32M
key_buffer_size = 32M


Anything below "Added by me" comment line didnt' exist before I modified the file. I checked my mysql verysion, it is 5.6+, and I was able to login mysql before I modified the my.conf file.
Apparenly the problem lies in the '[mysql]' block, but what is wrong?


Top
   
PostPosted: Mon Jan 04, 2016 1:06 pm 
Offline

Joined: Mon Jan 04, 2016 12:58 pm
Posts: 1
I am pretty sure [mysql] should be [mysqld]


Top
   
PostPosted: Mon Jan 04, 2016 1:47 pm 
Offline
Newbie

Joined: Wed Dec 30, 2015 11:48 am
Posts: 3
jeremye77 wrote:
I am pretty sure [mysql] should be [mysqld]


Thank you it works. Doesn't linode need to update their tutorial...


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: No registered users and 4 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group