Home > Database > Mysql Tutorial > mysql启动的时参数文件中的[mysql]下的参数没有生效

mysql启动的时参数文件中的[mysql]下的参数没有生效

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-06 09:33:02
Original
784 people have browsed it

mysql

my.cnf下的参数如下
[mysqld]
此处省略.....

[mysql]
#no-auto-rehash
prompt='\u@\h:\p\d mysql>'
#max_allowed_packet = 1024M ##影响mysql导人的速度
#default_character_set = gbk

启动方式
mysqld --defaults-file=/etc/my.cnf &

启动后prompt没有生效
[root@mysqldb15 ~]# mysql -uroot -p -S /tmp/mysql3306.sock
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.29-log MySQL Community Server (GPL)

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

求回复

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Issues
MySQL stops process
From 1970-01-01 08:00:00
0
0
0
Error when installing mysql on linux
From 1970-01-01 08:00:00
0
0
0
phpstudy cannot start mysql?
From 1970-01-01 08:00:00
0
0
0
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template