电子商务网站平台建设策划,购物商城模板,什么网站可以兼职做平面设计,便民的网站app怎么做mysqld --verbose --help#xff1a;可以显示 mysql 的编译配置选项#xff0c;即功能配置描述。mysql 显示所有支持的字符集#xff1a; SHOW CHARACTER SET;mysql 创建数据库或表的时候设置是否大小写敏感#xff1a;CREATE DATABASE test_database CHARACTER SET u…mysqld --verbose --help可以显示 mysql 的编译配置选项即功能配置描述。mysql 显示所有支持的字符集 SHOW CHARACTER SET;mysql 创建数据库或表的时候设置是否大小写敏感CREATE DATABASE test_database CHARACTER SET utf8 COLLATE utf8_general_cs; # 这句没什么用处见下面的解释。 cs 意思是 case sensitive当然你也可以在创建结束后使用alter来改变ALTER TABLE table_name MODIFY column_name column_datatype COLLATE utf8_general_ci; # 这句有效果 ci 意思是 case insensitive但是记住mysql的database和table都是操作系统的文件系统的目录或文件名因此不管你在创建他们时是否设置了大小写敏感他们都是和操作系统相关的即windows上数据库名和表名是大小写无关的而再linux上是大小写敏感的。只有表的column是和操作系统无关的因为他们不是目录入口因此你可以在创建column时设置column名是否大小写相关也可以使用alter来修改大小写敏感否。如果真的需要在linux下设置数据库名和table名大小写无关的话可以考虑使用lower_case_table_names变量但不保证有效可以了解下lower_case_table_nameshttps://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_lower_case_table_namesIf set to 0, table names are stored as specified and comparisons are case sensitive. If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive. If set to 2, table names are stored as given but compared in lowercase. This option also applies to database names and table aliases. For additional information, see Section 9.2.2, “Identifier Case Sensitivity”.mysql 的配置文件my.cnf调用次序(mysqld --verbose --help 的输出里有以下打印):Default options are read from the following files in the given order:/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnfInstallation(完整的安装帮助参考 INSTALL-BINARY 文件):To install and use a MySQL binary distribution, the basic command sequence looks like this:shell groupadd mysqlshell useradd -r -g mysql mysqlshell cd /usr/localshell tar zxvf /path/to/mysql-VERSION-OS.tar.gzshell ln -s full-path-to-mysql-VERSION-OS mysqlshell cd mysqlshell chown -R mysql .shell chgrp -R mysql .shell scripts/mysql_install_db --usermysqlshell chown -R root .shell chown -R mysql datashell bin/mysqld_safe --usermysql # Next command is optionalshell cp support-files/mysql.server /etc/init.d/mysql.server指定自己的 my.cnf 配置文件:mysqld_safe --defaults-fileFILE若运行时找不到 libaio.so , 可以: sudo apt-get install libaio1 libaio-dev首次启动时修改mysql的 rootlocalhost 的密码$ ./bin/mysql -urootmysql SET PASSWORD FOR rootlocalhost PASSWORD(your_passwd);mysql FLUSH PRIVILEGES;下次登录就要 ./bin/mysql -uroot -p修改密码$ mysqladmin -u root -p password newpasswordAdding User AccountsYou can create MySQL accounts two ways:By using account-management statements intended for creating accounts and establishing their privileges, such as CREATE USER and GRANT. These statements cause the server to make appropriate modifications to the underlying grant tables.By manipulating the MySQL grant tables directly with statements such as INSERT, UPDATE, or DELETE.The preferred method is to use account-management statements because they are more concise and less error-prone than manipulating the grant tables directly. All such statements are described in Section 13.7.1, “Account Management Statements”. Direct grant table manipulation is discouraged, and is not described here. The server is free to ignore rows that become malformed as a result of such modifications.Another option for creating accounts is to use the GUI tool MySQL Workbench. Also, several third-party programs offer capabilities for MySQL account administration. phpMyAdmin is one such program.The following examples show how to use the mysql client program to set up new accounts. These examples assume that privileges have been set up according to the defaults described in Section 2.12.4, “Securing the Initial MySQL Accounts”. This means that to make changes, you must connect to the MySQL server as the MySQL root user, which has the CREATE USER privilege.First, use the mysql program to connect to the server as the MySQL root user:shell mysql --userroot mysqlIf you have assigned a password to the root account, you must also supply a --password or -p option.After connecting to the server as root, you can add new accounts. The following example uses CREATE USER and GRANT statements to set up four accounts:mysql CREATE USER montylocalhost IDENTIFIED BY some_pass;mysql GRANT ALL PRIVILEGES ON *.* TO montylocalhost- WITH GRANT OPTION;mysql CREATE USER monty% IDENTIFIED BY some_pass;mysql GRANT ALL PRIVILEGES ON *.* TO monty%- WITH GRANT OPTION;mysql CREATE USER adminlocalhost IDENTIFIED BY admin_pass;mysql GRANT RELOAD,PROCESS ON *.* TO adminlocalhost;mysql CREATE USER dummylocalhost;The accounts created by those statements have the following properties:Two accounts have a user name of monty and a password of some_pass. Both are superuser accounts with full privileges to do anything. The montylocalhost account can be used only when connecting from the local host. The monty% account uses the % wildcard for the host part, so it can be used to connect from any host.The montylocalhost account is necessary if there is an anonymous-user account for localhost. Without the montylocalhost account, that anonymous-user account takes precedence when monty connects from the local host and monty is treated as an anonymous user. The reason for this is that the anonymous-user account has a more specific Host column value than the monty% account and thus comes earlier in the user table sort order. (user table sorting is discussed in Section 6.2.4, “Access Control, Stage 1: Connection Verification”.)The adminlocalhost account has a password of admin_pass. This account can be used only by admin to connect from the local host. It is granted the RELOAD and PROCESS administrative privileges. These privileges enable the admin user to execute the mysqladmin reload, mysqladmin refresh, and mysqladmin flush-xxx commands, as well as mysqladmin processlist . No privileges are granted for accessing any databases. You could add such privileges using GRANT statements.The dummylocalhost account has no password (which is insecure and not recommended). This account can be used only to connect from the local host. No privileges are granted. It is assumed that you will grant specific privileges to the account using GRANT statements.To see the privileges for an account, use SHOW GRANTS:mysql SHOW GRANTS FOR adminlocalhost;-----------------------------------------------------| Grants for adminlocalhost |-----------------------------------------------------| GRANT RELOAD, PROCESS ON *.* TO adminlocalhost |-----------------------------------------------------The next examples create three accounts and grant them access to specific databases. Each of them has a user name of custom and password of obscure:mysql CREATE USER customlocalhost IDENTIFIED BY obscure;mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP- ON bankaccount.*- TO customlocalhost;mysql CREATE USER customhost47.example.com IDENTIFIED BY obscure;mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP- ON expenses.*- TO customhost47.example.com;mysql CREATE USER custom%.example.com IDENTIFIED BY obscure;mysql GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP- ON customer.*- TO custom%.example.com;The three accounts can be used as follows:The first account can access the bankaccount database, but only from the local host.The second account can access the expenses database, but only from the host host47.example.com.The third account can access the customer database, from any host in the example.com domain. This account has access from all machines in the domain due to use of the “%” wildcard character in the host part of the account name.对于java ssh项目一般情况下只需要添加 montylocalhost 这样的一个用户就行了所有的远程访问都是通过他进行的所以不需要 monty% 这个用户。这个用户不安全。实例CREATE USER myuserlocalhost IDENTIFIED BY mypass;CREATE USER myuser% IDENTIFIED BY mypass;ThenGRANT ALL PRIVILEGES ON dbTest.* TO myuserlocalhost;GRANT ALL ON *.* TO myuserlocalhost;GRANT ALL ON *.* TO myuser%;
