当前位置:Gxlcms > 数据库问题 > Mysql

Mysql

时间:2021-07-01 10:21:17 帮助过:68人阅读

 

https://www.cnblogs.com/bookwed/p/5896619.html

https://www.cnblogs.com/phpxiebin/p/4988156.html

 

https://blog.csdn.net/skmbw/article/details/10832757

https://www.linuxidc.com/Linux/2008-12/17818.htm

https://blog.csdn.net/qq_15783243/article/details/78565705

 

https://blog.csdn.net/langzi7758521/article/details/51200834

https://blog.csdn.net/chszs/article/details/38758713

baigang@baigang-virtual-machine:/usr/local/mysql$ sudo cp support-files/mysql.server /etc/init.d/mysqld
[sudo] password for baigang:
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo chmod 755 /etc/init.d/mysqld
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo cp support-files/my-default.cnf /etc/my.cnf
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo vim /etc/init.d/mysqld
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo service mysqld start
Failed to start mysqld.service: Unit mysqld.service not found.
baigang@baigang-virtual-machine:/usr/local/mysql$ service mysqld start
Failed to start mysqld.service: Unit mysqld.service not found.
baigang@baigang-virtual-machine:/usr/local/mysql$ systemctl start mysqld.service
Failed to start mysqld.service: Unit mysqld.service not found.
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo systemctl start mysqld.service
Failed to start mysqld.service: Unit mysqld.service not found.
baigang@baigang-virtual-machine:/usr/local/mysql$ /etc/init.d/mysqld start
[....] Starting mysqld (via systemctl): mysqld.serviceFailed to start mysqld.service: Unit mysqld.service not found.
 failed!
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo /etc/init.d/mysqld start
[....] Starting mysqld (via systemctl): mysqld.serviceFailed to start mysqld.service: Unit mysqld.service not found.
 failed!

 

baigang@baigang-virtual-machine:/usr/local/mysql$ sudo systemctl enable mysqld.service  
mysqld.service is not a native service, redirecting to systemd-sysv-install
Executing /lib/systemd/systemd-sysv-install enable mysqld
baigang@baigang-virtual-machine:/usr/local/mysql$ sudo service mysqld start
baigang@baigang-virtual-machine:/usr/local/mysql$ ps aux|grep mysqld
root      19138  0.1  0.0   4504  1732 ?        S    13:18   0:00 /bin/sh /usr/local/mysql//bin/mysqld_safe --datadir=/usr/local/mysql/data/mysql --pid-file=/usr/local/mysql/data/mysql/baigang-virtual-machine.pid
mysql     19252  5.1 22.5 978116 454564 ?       Sl   13:18   0:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/mysql --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/mysql/baigang-virtual-machine.err --pid-file=/usr/local/mysql/data/mysql/baigang-virtual-machine.pid
baigang   19284  0.0  0.0  21296   940 pts/1    S+   13:19   0:00 grep --color=auto mysqld
baigang@baigang-virtual-machine:/usr/local/mysql$ ll
total 184
drwxr-xr-x 13 mysql mysql   4096 12月  4 12:25 ./
drwxr-xr-x 19 root  root    4096 12月  4 12:22 ../
drwxr-xr-x  2 mysql mysql   4096 12月  4 12:22 bin/
-rw-r--r--  1 mysql mysql  17987 12月  4 12:23 COPYING
drwxr-xr-x  4 mysql mysql   4096 12月  4 12:24 data/
drwxr-xr-x  2 mysql mysql   4096 12月  4 12:23 docs/
drwxr-xr-x  3 mysql mysql   4096 12月  4 12:22 include/
-rw-r--r--  1 mysql mysql 104897 12月  4 12:23 INSTALL-BINARY
drwxr-xr-x  3 mysql mysql   4096 12月  4 12:23 lib/
drwxr-xr-x  4 mysql mysql   4096 12月  4 12:23 man/
-rw-r--r--  1 root  root     943 12月  4 12:25 my.cnf
drwxr-xr-x 10 mysql mysql   4096 12月  4 12:23 mysql-test/
-rw-r--r--  1 mysql mysql   2496 12月  4 12:23 README
drwxr-xr-x  2 mysql mysql   4096 12月  4 12:23 scripts/
drwxr-xr-x 28 mysql mysql   4096 12月  4 12:23 share/
drwxr-xr-x  4 mysql mysql   4096 12月  4 12:23 sql-bench/
drwxr-xr-x  2 mysql mysql   4096 12月  4 12:23 support-files/
baigang@baigang-virtual-machine:/usr/local/mysql$ cd bin
baigang@baigang-virtual-machine:/usr/local/mysql/bin$ mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.26 MySQL Community Server (GPL)

Copyright (c) 2000, 2015, 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>
mysql>
mysql>
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
4 rows in set (0.13 sec)

 

https://www.cnblogs.com/lichangyun/p/9088139.html

http://www.cnblogs.com/fnlingnzb-learner/p/5830622.html

https://www.cnblogs.com/xinjing-jingxin/p/8025805.html

https://www.cnblogs.com/shizhongyang/p/8464876.html

https://blog.csdn.net/wwd0501/article/details/71171614

 

Mysql

标签:target   nec   sys   ngx   ocs   iat   end   help   may   

人气教程排行