mariadb unknown variable basediir

今天尝试了一下mariadb 的使用，配置基本上跟mysql一样，就是my.ini有几个，随便选择一个就行了，然后修改配置文件即可

[client]

#password= your_password

port= 3306

socket= E:/mariadb-10.1.18-winx64/tmp/mysql.sock

default-character-set=utf8

#default-storage-engine = MyISAM

# Here follows entries for some specific programs

 

# The MariaDB server

[mysqld]

port= 3306

socket= E:/mariadb-10.1.18-winx64/tmp/mysql.sock

basedir=E:/mariadb-10.1.18-winx64

datadir=E:/mariadb-10.1.18-winx64/data

character_set_server=utf8

skip-external-locking

#skip-grant-tables

key_buffer_size = 256M

max_allowed_packet = 1M

table_open_cache = 256

sort_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size = 4M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size= 16M

# Try number of CPU's*2 for thread_concurrency

thread_concurrency = 8

 

# Point the following paths to different dedicated disks

#tmpdir= /tmp/

 

# Replication Master Server (default)

# binary logging is required for replication

log-bin=mysql-bin

 

# binary logging format - mixed recommended

binlog_format=mixed

 

server-id= 1

 

# 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>

 

[mysqldump]

quick

max_allowed_packet = 16M

 

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

 

[myisamchk]

key_buffer_size = 128M

sort_buffer_size = 128M

read_buffer = 2M

write_buffer = 2M

 

[mysqlhotcopy]

interactive-timeout

 

[WinMySQLAdmin]   

Server=E:/mariadb-10.1.18-winx64/bin/mysqld.exe

 

刚开配置时在client下面也添加了basedir导致启动的时候宝 unknown variable basedir的错误，删除client下的basedir 即可，mysqld下面必须配置