中标麒麟安装mysql11数据库
曾经在中标麒麟上安装过mysql，记录一下。不具有普遍性，仅供参考。
1 [lssecure@localhost mysql]$ su 2 密码： 3 [root@localhost mysql]# rpm -ivh qt-mysql-4.8.4-19.nk.1.i686.rpm 4 警告：qt-mysql-4.8.4-19.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 5 错误：Failed dependencies: 6 libmysqlclient.so.18 is needed by qt-mysql-1:4.8.4-19.nk.1.i686 7 libmysqlclient.so.18(libmysqlclient_16) is needed by qt-mysql-1:4.8.4-19.nk.1.i686 8 [root@localhost mysql]# rpm -ivh mariadb-libs-5.5.39-1.nk.1.i686.rpm 9 警告：mariadb-libs-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 10 准备中... ################################# [100%] 11 正在升级/安装... 12 1:mariadb-libs-1:5.5.39-1.nk.1 ################################# [100%] 13 /sbin/ldconfig: /opt/remote-viewer/libs/libspice-client-gtk-2.0.so.1 不是符号连接 14 15 /sbin/ldconfig: /opt/remote-viewer/libs/libspice-client-glib-2.0.so.1 不是符号连接 16 17 /sbin/ldconfig: /opt/remote-viewer/libs/libspice-controller.so.0 不是符号连接 18 19 [root@localhost mysql]# rpm -ivh qt-mysql-4.8.4-19.nk.1.i686.rpm 20 警告：qt-mysql-4.8.4-19.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 21 准备中... ################################# [100%] 22 正在升级/安装... 23 1:qt-mysql-1:4.8.4-19.nk.1 ################################# [100%] 24 [root@localhost mysql]# rpm -ivh mariadb-server-5.5.39-1.nk.1.i686.rpm 25 警告：mariadb-server-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 26 错误：Failed dependencies: 27 mariadb(x86-32) = 1:5.5.39-1.nk.1 is needed by mariadb-server-1:5.5.39-1.nk.1.i686 28 perl(DBI) is needed by mariadb-server-1:5.5.39-1.nk.1.i686 29 perl-DBD-MySQL is needed by mariadb-server-1:5.5.39-1.nk.1.i686 30 perl-DBI is needed by mariadb-server-1:5.5.39-1.nk.1.i686 31 [root@localhost mysql]# rpm -ivh 32 rpm：未给出要安装的软件包 33 [root@localhost mysql]# rpm -ivh perl-BDB-1.90-4.nk.1.i686.rpm 34 警告：perl-BDB-1.90-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 35 错误：Failed dependencies: 36 perl(common::sense) is needed by perl-BDB-1.90-4.nk.1.i686 37 [root@localhost mysql]# rpm -ivh perl-DBD-MySQL-4.023-2.nk.1.i686.rpm 38 警告：perl-DBD-MySQL-4.023-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 39 错误：Failed dependencies: 40 perl(DBI) is needed by perl-DBD-MySQL-4.023-2.nk.1.i686 41 perl(DBI::Const::GetInfoType) is needed by perl-DBD-MySQL-4.023-2.nk.1.i686 42 [root@localhost mysql]# rpm -ivh perl-DBI-1.623-2.nk.1.i686.rpm 43 警告：perl-DBI-1.623-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 44 错误：Failed dependencies: 45 perl(Coro) is needed by perl-DBI-1.623-2.nk.1.i686 46 perl(Coro::Handle) is needed by perl-DBI-1.623-2.nk.1.i686 47 perl(Coro::Select) is needed by perl-DBI-1.623-2.nk.1.i686 48 perl(RPC::PlClient) >= 0.2000 is needed by perl-DBI-1.623-2.nk.1.i686 49 perl(RPC::PlServer) >= 0.2001 is needed by perl-DBI-1.623-2.nk.1.i686 50 [root@localhost mysql]# 51 [root@localhost mysql]# rpm -ivh perl-Coro-6.23-2.nk.1.i686.rpm 52 警告：perl-Coro-6.23-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 53 错误：Failed dependencies: 54 perl(AnyEvent) >= 7 is needed by perl-Coro-6.23-2.nk.1.i686 55 perl(AnyEvent::AIO) >= 1 is needed by perl-Coro-6.23-2.nk.1.i686 56 perl(AnyEvent::BDB) >= 1 is needed by perl-Coro-6.23-2.nk.1.i686 57 perl(AnyEvent::DNS) is needed by perl-Coro-6.23-2.nk.1.i686 58 perl(AnyEvent::Socket) is needed by perl-Coro-6.23-2.nk.1.i686 59 perl(AnyEvent::Util) is needed by perl-Coro-6.23-2.nk.1.i686 60 perl(BDB) is needed by perl-Coro-6.23-2.nk.1.i686 61 perl(EV) >= 4 is needed by perl-Coro-6.23-2.nk.1.i686 62 perl(Event) >= 1.08 is needed by perl-Coro-6.23-2.nk.1.i686 63 perl(Guard) >= 0.5 is needed by perl-Coro-6.23-2.nk.1.i686 64 perl(IO::AIO) >= 3.1 is needed by perl-Coro-6.23-2.nk.1.i686 65 perl(common::sense) is needed by perl-Coro-6.23-2.nk.1.i686 66 [root@localhost mysql]# rpm -ivh perl-AnyEvent-7.04-2.nk.1.i686.rpm 67 警告：perl-AnyEvent-7.04-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 68 错误：Failed dependencies: 69 perl(Task::Weaken) is needed by perl-AnyEvent-7.04-2.nk.1.i686 70 [root@localhost mysql]# rpm -ivh perl-Task-Weaken-1.04-6.nk.1.noarch.rpm 71 警告：perl-Task-Weaken-1.04-6.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 72 准备中... ################################# [100%] 73 正在升级/安装... 74 1:perl-Task-Weaken-1.04-6.nk.1 ################################# [100%] 75 [root@localhost mysql]# rpm -ivh perl-Coro-6.23-2.nk.1.i686.rpm 76 警告：perl-Coro-6.23-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 77 错误：Failed dependencies: 78 perl(AnyEvent) >= 7 is needed by perl-Coro-6.23-2.nk.1.i686 79 perl(AnyEvent::AIO) >= 1 is needed by perl-Coro-6.23-2.nk.1.i686 80 perl(AnyEvent::BDB) >= 1 is needed by perl-Coro-6.23-2.nk.1.i686 81 perl(AnyEvent::DNS) is needed by perl-Coro-6.23-2.nk.1.i686 82 perl(AnyEvent::Socket) is needed by perl-Coro-6.23-2.nk.1.i686 83 perl(AnyEvent::Util) is needed by perl-Coro-6.23-2.nk.1.i686 84 perl(BDB) is needed by perl-Coro-6.23-2.nk.1.i686 85 perl(EV) >= 4 is needed by perl-Coro-6.23-2.nk.1.i686 86 perl(Event) >= 1.08 is needed by perl-Coro-6.23-2.nk.1.i686 87 perl(Guard) >= 0.5 is needed by perl-Coro-6.23-2.nk.1.i686 88 perl(IO::AIO) >= 3.1 is needed by perl-Coro-6.23-2.nk.1.i686 89 perl(common::sense) is needed by perl-Coro-6.23-2.nk.1.i686 90 [root@localhost mysql]# rpm -ivh perl-AnyEvent-7.04-2.nk.1.i686.rpm 91 警告：perl-AnyEvent-7.04-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 92 准备中... ################################# [100%] 93 正在升级/安装... 94 1:perl-AnyEvent-7.04-2.nk.1 ################################# [100%] 95 [root@localhost mysql]# rpm -ivh perl-DBD-MySQL-4.023-2.nk.1.i686.rpm 96 警告：perl-DBD-MySQL-4.023-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 97 错误：Failed dependencies: 98 perl(DBI) is needed by perl-DBD-MySQL-4.023-2.nk.1.i686 99 perl(DBI::Const::GetInfoType) is needed by perl-DBD-MySQL-4.023-2.nk.1.i686 100 [root@localhost mysql]# ls 101 keyutils-libs-devel-1.5.5-4.nk.1.i686.rpm 102 krb5-devel-1.11.3-1.nk.1.i686.rpm 103 libcom_err-devel-1.42.7-2.nk.1.i686.rpm 104 libdbi-0.8.4-3.nk.1.i686.rpm 105 libdbi-dbd-mysql-0.8.3-12.nk.1.i686.rpm 106 libdbi-drivers-0.8.3-12.nk.1.i686.rpm 107 libselinux-devel-2.1.13-15.nk.1.i686.rpm 108 libsepol-devel-2.1.9-1.nk.1.i686.rpm 109 libverto-devel-0.2.5-2.nk.1.i686.rpm 110 libzip-0.10.1-6.nk.1.i686.rpm 111 mariadb-5.5.39-1.nk.1.i686.rpm 112 mariadb-bench-5.5.39-1.nk.1.i686.rpm 113 mariadb-devel-5.5.39-1.nk.1.i686.rpm 114 mariadb-libs-5.5.39-1.nk.1.i686.rpm 115 mariadb-server-5.5.39-1.nk.1.i686.rpm 116 mysql-connector-odbc-5.2.5-1.nk.1.i686.rpm 117 MySQL-python-1.2.3-7.nk.1.i686.rpm 118 mysqltuner-1.2.0-4.nk.1.noarch.rpm 119 openssl-devel-1.0.1e-4.nk.1.i686.rpm 120 perl-AnyEvent-7.04-2.nk.1.i686.rpm 121 perl-AnyEvent-AIO-1.1-11.nk.1.noarch.rpm 122 perl-AnyEvent-BDB-1.1-10.nk.1.noarch.rpm 123 perl-BDB-1.90-4.nk.1.i686.rpm 124 perl-common-sense-3.6-4.nk.1.noarch.rpm 125 perl-Coro-6.23-2.nk.1.i686.rpm 126 perl-DBD-MySQL-4.023-2.nk.1.i686.rpm 127 perl-DBI-1.623-2.nk.1.i686.rpm 128 perl-EV-4.11-2.nk.1.i686.rpm 129 perl-Event-1.21-2.nk.1.i686.rpm 130 perl-GD-2.46-3.nk.1.i686.rpm 131 perl-Guard-1.022-4.nk.1.i686.rpm 132 perl-IO-AIO-4.15-4.nk.1.i686.rpm 133 perl-Net-Daemon-0.48-5.nk.1.noarch.rpm 134 perl-PlRPC-0.2020-13.nk.1.noarch.rpm 135 perl-Task-Weaken-1.04-6.nk.1.noarch.rpm 136 php-cli-5.5.0-0.10.RC3.nk.1.i686.rpm 137 php-common-5.5.0-0.10.RC3.nk.1.i686.rpm 138 php-mysqlnd-5.5.0-0.10.RC3.nk.1.i686.rpm 139 php-pdo-5.5.0-0.10.RC3.nk.1.i686.rpm 140 php-pear-1.9.4-18.nk.1.noarch.rpm 141 php-pecl-jsonc-1.3.1-1.nk.1.i686.rpm 142 php-process-5.5.0-0.10.RC3.nk.1.i686.rpm 143 php-xml-5.5.0-0.10.RC3.nk.1.i686.rpm 144 qt3-MySQL-3.3.8b-58.nk.1.i686.rpm 145 qt-mysql-4.8.4-19.nk.1.i686.rpm 146 unixODBC-2.3.1-4.nk.1.i686.rpm 147 zlib-devel-1.2.7-10.nk.1.i686.rpm 148 [root@localhost mysql]# rpm -ivh perl-DBI-1.623-2.nk.1.i686.rpm 149 警告：perl-DBI-1.623-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 150 错误：Failed dependencies: 151 perl(Coro) is needed by perl-DBI-1.623-2.nk.1.i686 152 perl(Coro::Handle) is needed by perl-DBI-1.623-2.nk.1.i686 153 perl(Coro::Select) is needed by perl-DBI-1.623-2.nk.1.i686 154 perl(RPC::PlClient) >= 0.2000 is needed by perl-DBI-1.623-2.nk.1.i686 155 perl(RPC::PlServer) >= 0.2001 is needed by perl-DBI-1.623-2.nk.1.i686 156 [root@localhost mysql]# rpm -ivh perl-Coro-6.23-2.nk.1.i686.rpm 157 警告：perl-Coro-6.23-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 158 错误：Failed dependencies: 159 perl(AnyEvent::AIO) >= 1 is needed by perl-Coro-6.23-2.nk.1.i686 160 perl(AnyEvent::BDB) >= 1 is needed by perl-Coro-6.23-2.nk.1.i686 161 perl(BDB) is needed by perl-Coro-6.23-2.nk.1.i686 162 perl(EV) >= 4 is needed by perl-Coro-6.23-2.nk.1.i686 163 perl(Event) >= 1.08 is needed by perl-Coro-6.23-2.nk.1.i686 164 perl(Guard) >= 0.5 is needed by perl-Coro-6.23-2.nk.1.i686 165 perl(IO::AIO) >= 3.1 is needed by perl-Coro-6.23-2.nk.1.i686 166 perl(common::sense) is needed by perl-Coro-6.23-2.nk.1.i686 167 [root@localhost mysql]# rpm -ivh perl-AnyEvent-AIO-1.1-11.nk.1.noarch.rpm 168 警告：perl-AnyEvent-AIO-1.1-11.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 169 错误：Failed dependencies: 170 perl(IO::AIO) is needed by perl-AnyEvent-AIO-1.1-11.nk.1.noarch 171 [root@localhost mysql]# rpm -ivh perl-IO-AIO-4.15-4.nk.1.i686.rpm 172 警告：perl-IO-AIO-4.15-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 173 错误：Failed dependencies: 174 perl(common::sense) is needed by perl-IO-AIO-4.15-4.nk.1.i686 175 [root@localhost mysql]# rpm -ivh perl-common-sense-3.6-4.nk.1.noarch.rpm 176 警告：perl-common-sense-3.6-4.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 177 准备中... ################################# [100%] 178 正在升级/安装... 179 1:perl-common-sense-3.6-4.nk.1 ################################# [100%] 180 [root@localhost mysql]# rpm -ivh perl-IO-AIO-4.15-4.nk.1.i686.rpm 181 警告：perl-IO-AIO-4.15-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 182 准备中... ################################# [100%] 183 正在升级/安装... 184 1:perl-IO-AIO-4.15-4.nk.1 ################################# [100%] 185 [root@localhost mysql]# rpm -ivh perl-AnyEvent-AIO-1.1-11.nk.1.noarch.rpm 186 警告：perl-AnyEvent-AIO-1.1-11.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 187 准备中... ################################# [100%] 188 正在升级/安装... 189 1:perl-AnyEvent-AIO-1.1-11.nk.1 ################################# [100%] 190 [root@localhost mysql]# rpm -ivh perl-AnyEvent-BDB-1.1-10.nk.1.noarch.rpm 191 警告：perl-AnyEvent-BDB-1.1-10.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 192 错误：Failed dependencies: 193 perl(BDB) is needed by perl-AnyEvent-BDB-1.1-10.nk.1.noarch 194 [root@localhost mysql]# rpm -ivh perl-BDB-1.90-4.nk.1.i686.rpm 195 警告：perl-BDB-1.90-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 196 准备中... ################################# [100%] 197 正在升级/安装... 198 1:perl-BDB-1.90-4.nk.1 ################################# [100%] 199 [root@localhost mysql]# rpm -ivh perl-AnyEvent-BDB-1.1-10.nk.1.noarch.rpm 200 警告：perl-AnyEvent-BDB-1.1-10.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 201 准备中... ################################# [100%] 202 正在升级/安装... 203 1:perl-AnyEvent-BDB-1.1-10.nk.1 ################################# [100%] 204 [root@localhost mysql]# rpm -ivh perl-EV-4.11-2.nk.1.i686.rpm 205 警告：perl-EV-4.11-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 206 准备中... ################################# [100%] 207 正在升级/安装... 208 1:perl-EV-4.11-2.nk.1 ################################# [100%] 209 [root@localhost mysql]# rpm -ivh perl-Event-1.21-2.nk.1.i686.rpm 210 警告：perl-Event-1.21-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 211 准备中... ################################# [100%] 212 正在升级/安装... 213 1:perl-Event-1.21-2.nk.1 ################################# [100%] 214 [root@localhost mysql]# rpm -ivh perl-Guard-1.022-4.nk.1.i686.rpm 215 警告：perl-Guard-1.022-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 216 准备中... ################################# [100%] 217 正在升级/安装... 218 1:perl-Guard-1.022-4.nk.1 ################################# [100%] 219 [root@localhost mysql]# rpm -ivh perl-Coro-6.23-2.nk.1.i686.rpm 220 警告：perl-Coro-6.23-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 221 准备中... ################################# [100%] 222 正在升级/安装... 223 1:perl-Coro-6.23-2.nk.1 ################################# [100%] 224 [root@localhost mysql]# rpm -ivh perl-PlRPC-0.2020-13.nk.1.noarch.rpm 225 警告：perl-PlRPC-0.2020-13.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 226 错误：Failed dependencies: 227 perl(Net::Daemon) >= 0.13 is needed by perl-PlRPC-0.2020-13.nk.1.noarch 228 perl(Net::Daemon::Log) is needed by perl-PlRPC-0.2020-13.nk.1.noarch 229 perl(Net::Daemon::Test) is needed by perl-PlRPC-0.2020-13.nk.1.noarch 230 [root@localhost mysql]# rpm -ivh perl-DBI-1.623-2.nk.1.i686.rpm 231 警告：perl-DBI-1.623-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 232 错误：Failed dependencies: 233 perl(RPC::PlClient) >= 0.2000 is needed by perl-DBI-1.623-2.nk.1.i686 234 perl(RPC::PlServer) >= 0.2001 is needed by perl-DBI-1.623-2.nk.1.i686 235 [root@localhost mysql]# rpm -ivh perl-Net-Daemon-0.48-5.nk.1.noarch.rpm 236 警告：perl-Net-Daemon-0.48-5.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 237 准备中... ################################# [100%] 238 正在升级/安装... 239 1:perl-Net-Daemon-0.48-5.nk.1 ################################# [100%] 240 [root@localhost mysql]# rpm -ivh perl-PlRPC-0.2020-13.nk.1.noarch.rpm 241 警告：perl-PlRPC-0.2020-13.nk.1.noarch.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 242 准备中... ################################# [100%] 243 正在升级/安装... 244 1:perl-PlRPC-0.2020-13.nk.1 ################################# [100%] 245 [root@localhost mysql]# rpm -ivh perl-DBI-1.623-2.nk.1.i686.rpm 246 警告：perl-DBI-1.623-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 247 准备中... ################################# [100%] 248 正在升级/安装... 249 1:perl-DBI-1.623-2.nk.1 ################################# [100%] 250 [root@localhost mysql]# rpm -ivh perl-DBD-MySQL-4.023-2.nk.1.i686.rpm 251 警告：perl-DBD-MySQL-4.023-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 252 准备中... ################################# [100%] 253 正在升级/安装... 254 1:perl-DBD-MySQL-4.023-2.nk.1 ################################# [100%] 255 [root@localhost mysql]# rpm -ivh mariadb-server-5.5.39-1.nk.1.i686.rpm 256 警告：mariadb-server-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 257 错误：Failed dependencies: 258 mariadb(x86-32) = 1:5.5.39-1.nk.1 is needed by mariadb-server-1:5.5.39-1.nk.1.i686 259 [root@localhost mysql]# rpm -ivh mariadb-5.5.39-1.nk.1.i686.rpm 260 警告：mariadb-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 261 准备中... ################################# [100%] 262 正在升级/安装... 263 1:mariadb-1:5.5.39-1.nk.1 ################################# [100%] 264 [root@localhost mysql]# rpm -ivh mariadb-server-5.5.39-1.nk.1.i686.rpm 265 警告：mariadb-server-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 266 准备中... ################################# [100%] 267 正在升级/安装... 268 1:mariadb-server-1:5.5.39-1.nk.1 ################################# [100%] 269 [root@localhost mysql]# vi /etc/my.cnf 270 [root@localhost mysql]# vi /etc/my.cnf 271 [root@localhost mysql]# vi /etc/my.cnf.d/client.cnf 272 [root@localhost mysql]# vi /etc/my.cnf.d/mysql-clients.cnf 273 [root@localhost mysql]# systemctl restart mariadb 274 [root@localhost mysql]# mysql -u root -p 275 Enter password: 276 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) 277 [root@localhost mysql]# mysql -u root -p 278 Enter password: 279 Welcome to the MariaDB monitor. Commands end with ; or \g. 280 Your MariaDB connection id is 3 281 Server version: 5.5.39-MariaDB MariaDB Server 282 283 Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. 284 285 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 286 287 MariaDB [(none)]> show variables like "%character%";show variables like "%collation%"; 288 +--------------------------+----------------------------+ 289 | Variable_name | Value | 290 +--------------------------+----------------------------+ 291 | character_set_client | utf8 | 292 | character_set_connection | utf8 | 293 | character_set_database | utf8 | 294 | character_set_filesystem | binary | 295 | character_set_results | utf8 | 296 | character_set_server | utf8 | 297 | character_set_system | utf8 | 298 | character_sets_dir | /usr/share/mysql/charsets/ | 299 +--------------------------+----------------------------+ 300 8 rows in set (0.00 sec) 301 302 +----------------------+-----------------+ 303 | Variable_name | Value | 304 +----------------------+-----------------+ 305 | collation_connection | utf8_unicode_ci | 306 | collation_database | utf8_unicode_ci | 307 | collation_server | utf8_unicode_ci | 308 +----------------------+-----------------+ 309 3 rows in set (0.00 sec) 310 311 MariaDB [(none)]> Ctrl-C -- exit! 312 Aborted 313 [root@localhost mysql]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld 314 cp: 无法获取"/usr/local/mysql/support-files/mysql.server" 的文件状态(stat): 没有那个文件或目录 315 [root@localhost mysql]# mysql -uroot -p 316 Enter password: 317 Welcome to the MariaDB monitor. Commands end with ; or \g. 318 Your MariaDB connection id is 4 319 Server version: 5.5.39-MariaDB MariaDB Server 320 321 Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. 322 323 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 324 325 MariaDB [(none)]> Ctrl-C -- exit! 326 Aborted 327 [root@localhost mysql]# mysqladmin -u root -p password lssecure 328 Enter password: 329 [root@localhost mysql]# mysql -uroot -p 330 Enter password: 331 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) 332 [root@localhost mysql]# mysql -uroot -p 333 Enter password: 334 Welcome to the MariaDB monitor. Commands end with ; or \g. 335 Your MariaDB connection id is 7 336 Server version: 5.5.39-MariaDB MariaDB Server 337 338 Copyright (c) 2000, 2014, Oracle, Monty Program Ab and others. 339 340 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 341 342 MariaDB [(none)]> Ctrl-C -- exit! 343 Aborted 344 [root@localhost mysql]# 345 346 347 348 [root@localhost mysql]# yum search mysql 349 已加载插件：langpacks, refresh-packagekit 350 http://download.cs2c.com.cn/neokylin/desktop/releases/4.0/i386/zy/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found 351 正在尝试其它镜像。 352 错误：failure: repodata/repomd.xml from neokylin: [Errno 256] No more mirrors to try. 353 http://download.cs2c.com.cn/neokylin/desktop/releases/4.0/i386/zy/repodata/repomd.xml: [Errno 14] HTTP Error 404 - Not Found 354 [root@localhost mysql]# rpm -ivh mariadb-devel-5.5.39-1.nk.1.i686.rpm 355 警告：mariadb-devel-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 356 错误：Failed dependencies: 357 openssl-devel(x86-32) is needed by mariadb-devel-1:5.5.39-1.nk.1.i686 358 [root@localhost mysql]# rpm -ivh openssl-devel-1.0.1e-4.nk.1.i686.rpm 359 警告：openssl-devel-1.0.1e-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 360 错误：Failed dependencies: 361 krb5-devel(x86-32) is needed by openssl-devel-1:1.0.1e-4.nk.1.i686 362 [root@localhost mysql]# rpm -ivh krb5-devel-1.11.3-1.nk.1.i686.rpm 363 警告：krb5-devel-1.11.3-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 364 错误：Failed dependencies: 365 keyutils-libs-devel is needed by krb5-devel-1.11.3-1.nk.1.i686 366 libcom_err-devel is needed by krb5-devel-1.11.3-1.nk.1.i686 367 libselinux-devel is needed by krb5-devel-1.11.3-1.nk.1.i686 368 libverto-devel is needed by krb5-devel-1.11.3-1.nk.1.i686 369 [root@localhost mysql]# rpm -ivh keyutils-libs-devel-1.5.5-4.nk.1.i686.rpm 370 警告：keyutils-libs-devel-1.5.5-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 371 准备中... ################################# [100%] 372 正在升级/安装... 373 1:keyutils-libs-devel-1.5.5-4.nk.1 ################################# [100%] 374 [root@localhost mysql]# rpm -ivh libselinux-devel-2.1.13-15.nk.1.i686.rpm 375 警告：libselinux-devel-2.1.13-15.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 376 错误：Failed dependencies: 377 libsepol-devel >= 2.1.9-1 is needed by libselinux-devel-2.1.13-15.nk.1.i686 378 pkgconfig(libsepol) is needed by libselinux-devel-2.1.13-15.nk.1.i686 379 [root@localhost mysql]# rpm -ivh libsepol-devel-2.1.9-1.nk.1.i686.rpm 380 警告：libsepol-devel-2.1.9-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 381 准备中... ################################# [100%] 382 正在升级/安装... 383 1:libsepol-devel-2.1.9-1.nk.1 ################################# [100%] 384 [root@localhost mysql]# rpm -ivh libselinux-devel-2.1.13-15.nk.1.i686.rpm 385 警告：libselinux-devel-2.1.13-15.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 386 准备中... ################################# [100%] 387 正在升级/安装... 388 1:libselinux-devel-2.1.13-15.nk.1 ################################# [100%] 389 [root@localhost mysql]# rpm -ivh libverto-devel-0.2.5-2.nk.1.i686.rpm 390 警告：libverto-devel-0.2.5-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 391 准备中... ################################# [100%] 392 正在升级/安装... 393 1:libverto-devel-0.2.5-2.nk.1 ################################# [100%] 394 [root@localhost mysql]# rpm -ivh libcom_err-devel-1.42.7-2.nk.1.i686.rpm 395 警告：libcom_err-devel-1.42.7-2.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 396 准备中... ################################# [100%] 397 正在升级/安装... 398 1:libcom_err-devel-1.42.7-2.nk.1 ################################# [100%] 399 [root@localhost mysql]# rpm -ivh krb5-devel-1.11.3-1.nk.1.i686.rpm 400 警告：krb5-devel-1.11.3-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 401 准备中... ################################# [100%] 402 正在升级/安装... 403 1:krb5-devel-1.11.3-1.nk.1 ################################# [100%] 404 [root@localhost mysql]# rpm -ivh openssl-devel-1.0.1e-4.nk.1.i686.rpm 405 警告：openssl-devel-1.0.1e-4.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 406 准备中... ################################# [100%] 407 正在升级/安装... 408 1:openssl-devel-1:1.0.1e-4.nk.1 ################################# [100%] 409 [root@localhost mysql]# rpm -ivh mariadb-devel-5.5.39-1.nk.1.i686.rpm 410 警告：mariadb-devel-5.5.39-1.nk.1.i686.rpm: Header V4 RSA/SHA1 Signature, key ID 34fe765a: NOKEY 411 准备中... ################################# [100%] 412 正在升级/安装... 413 1:mariadb-devel-1:5.5.39-1.nk.1 ################################# [100%] 414 [root@localhost mysql]# rp 415 416 417 418 配置字符集 419 2、配置MariaDB的字符集 420 421 文件/etc/my.cnf 422 423 vi /etc/my.cnf 424 在[mysqld]标签下添加 425 426 init_connect='SET collation_connection = utf8_unicode_ci' 427 init_connect='SET NAMES utf8' 428 character-set-server=utf8 429 collation-server=utf8_unicode_ci 430 skip-character-set-client-handshake 431 文件/etc/my.cnf.d/client.cnf 432 433 vi /etc/my.cnf.d/client.cnf 434 在[client]中添加 435 436 default-character-set=utf8 437 文件/etc/my.cnf.d/mysql-clients.cnf 438 439 vi /etc/my.cnf.d/mysql-clients.cnf 440 在[mysql]中添加 441 442 default-character-set=utf8 443 全部配置完成，重启mariadb 444 445 systemctl restart mariadb 446 之后进入MariaDB查看字符集 447 448 [root@localhost ~]# mysql -u root -p 449 Enter password: 450 Welcome to the MariaDB monitor. Commands end with ; or \g. 451 Your MariaDB connection id is 14 452 Server version: 5.5.56-MariaDB MariaDB Server 453 454 Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. 455 456 Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 457 458 MariaDB [(none)]> show variables like "%character%";show variables like "%collation%"; 459 +--------------------------+----------------------------+ 460 | Variable_name | Value | 461 +--------------------------+----------------------------+ 462 | character_set_client | utf8 | 463 | character_set_connection | utf8 | 464 | character_set_database | latin1 | 465 | character_set_filesystem | binary | 466 | character_set_results | utf8 | 467 | character_set_server | latin1 | 468 | character_set_system | utf8 | 469 | character_sets_dir | /usr/share/mysql/charsets/ | 470 +--------------------------+----------------------------+ 471 8 rows in set (0.01 sec) 472 473 +----------------------+-------------------+ 474 | Variable_name | Value | 475 +----------------------+-------------------+ 476 | collation_connection | utf8_general_ci | 477 | collation_database | latin1_swedish_ci | 478 | collation_server | latin1_swedish_ci | 479 +----------------------+-------------------+ 480 3 rows in set (0.00 sec) 481 482 483 484 连接不上的问题 485 cd mysql安装目录\bin 486 mysql -u root -p123456; 487 mysql GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; 488 mysql flush privileges; 489 490 491 492 493 494 495 496 7.安装完成后，启动mariadb服务端 497 498 systemctl start/stop/restart/status mariadb 499 systemctl enable mariadb 开机启动mariadb 500 501 8.mysql初始化 502 503 # 这条命令可以初始化mysql，删除匿名用户，设置root密码等等.... 504 mysql_secure_installation 505 506 9.设置mysql的中文编码支持，修改/etc/my.cnf 507 1.vi /etc/my.cnf 508 509 在[mysqld]中添加参数，使得mariadb服务端支持中文 510 [mysqld] 511 character-set-server=utf8 512 collation-server=utf8_general_ci 513 2.重启mariadb服务，读取my.cnf新配置 514 515 systemctl restart mariadb 516 3.登录数据库，查看字符编码 517 518 mysql -uroot -p 519 输入 \s 查看编码 520 521 10.mysql常用命令 522 523 复制代码 524 desc #查看表结构 525 create database #数据库名 526 create table #表名 527 查看如何创建db的 528 show create database #库名 529 # 查看如何创建table结构的 530 show create table 表名; 531 532 # 修改mysql的密码 533 set password = PASSWORD('redhat'); 534 535 # 创建mysql的普通用户，默认权限非常低 536 create user yining@'%' identified by 'yiningzhenshuai'; 537 538 # 查询mysql数据库中的用户信息 539 use mysql; 540 select host,user,password from user; 541 复制代码 542 543 11.给用户添加权限命令 544 545 复制代码 546 # 对所有库和所有表授权所有权限 547 grant all privileges on *.* to 账户@主机名 548 # 给yining用户授予所有权限 549 grant all privileges on *.* to yining@'%'; 550 # 刷新授权表 551 flush privileges; 552 复制代码 553 554 12.授予远程登录的权限命令(root不能远程登录的问题？？) 555 556 复制代码 557 # 给apollo用户授予所有权限 558 grant all privileges on *.* to apollo@'%'; 559 # 给与root权限授予远程登录的命令 560 # 'centos这是密码随意设置 561 grant all privileges on *.* to root@'%' identified by 'centos'; 562 # 此时可以在windows登录linux的数据库 563 # 连接服务器的mysql 564 mysql -uyining -p -h 服务器的地址 565 复制代码 566 567 13.学习mysql的数据备份与恢复 568 569 复制代码 570 # 导出当前数据库的所有db,到一个文件中 571 1.mysqldump -u root -p --all-databases > /data/AllMysql.dump 572 2.登录mysql 导入数据 573 mysql -u root -p 574 > source /data/AllMysql.dump 575 3.通过命令导入数据 576 # 在登录时候，导入数据文件，一样可以写入数据 577 mysql -uroot -p < /data/AllMysql.dump 578 复制代码
