继上次进行初始化后，然后尝试启动mysql程序，当时也不知道哪个文件是可以启动mysql的文件，然后继续百度。
发现 /usr/local/mysql/share/mysql 下面找到了传说中的 mysql.server 文件.
然后尝试运行此文件:
root@b-ThinkPad-X230s:/usr/local/mysql/share/mysql# ./mysql.server startStarting MySQL. * Manager of pid-file quit without updating file. (这里出现问题了，然后网上百度了半天，发现大家的解决方法并不适合我的，也许解决问题的本质是一样的吧，我目前还不清楚)然后就一直卡在这里了。目前也不知道哪里可以看到 mysql的错误日志，下来慢慢找 。
索性直接查看 mysql.server这个脚本文件，发现：
basedir= (空的？)datadir=
因为我也不知道具体机制是如何的，感觉不应该这样，索性填写目录进去：
basedir=/usr/local/mysql/datadir=/usr/local/mysql/data/保存，退出。
再次尝试运行：
root@b-ThinkPad-X230s:/usr/local/mysql/share/mysql# ./mysql.server startStarting MySQL. * 看起来成功了！
然后验证一下是否已经在运行了：
root@b-ThinkPad-X230s:/usr/local/mysql/share/mysql# ps -aux | grep "my"root 6128 0.0 0.0 4476 1732 pts/4 S 15:14 0:00 /bin/sh /usr/local/mysql//bin/mysqld_safe --datadir=/usr/local/mysql/data/ --pid-file=/usr/local/mysql/data//b-ThinkPad-X230s.pidmysql 6197 0.0 0.1 118412 9580 pts/4 Sl 15:14 0:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data/ --user=mysql --log-error=/usr/local/mysql/data//b-ThinkPad-X230s.err --pid-file=/usr/local/mysql/data//b-ThinkPad-X230s.pidroot 6207 0.0 0.0 13708 2184 pts/4 S+ 15:16 0:00 grep --color=auto my有进程了！
然后尝试进入mysql （至此，我还是一头雾水，目前还有帐号的问题和实例的问题比较模糊，因为进程中出现的是/usr/local/mysql//bin/mysqld_safe，目前还不了解这个是什么意思！）
root@b-ThinkPad-X230s:/usr/local/mysql/bin# sudo ./mysqlWelcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 1Server version: 5.1.70 Source distributionCopyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql>
然后找了懂的大神操作了如下内容证明没有问题，我还不明白具体是什么意思，下来继续学习：
mysql> show tables;+---------------------------+| Tables_in_mysql |+---------------------------+| columns_priv || db || event || func || general_log || help_category || help_keyword || help_relation || help_topic || host || ndb_binlog_index || plugin || proc || procs_priv || servers || slow_log || tables_priv || time_zone || time_zone_leap_second || time_zone_name || time_zone_transition || time_zone_transition_type || user |+---------------------------+23 rows in set (0.00 sec)mysql> select * from db;+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+| Host | Db | User | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Create_tmp_table_priv | Lock_tables_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Execute_priv | Event_priv | Trigger_priv |+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+| % | test | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | N | N | Y | Y || % | test\_% | | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | N | N | Y | Y |+------+---------+------+-------------+-------------+-------------+-------------+-------------+-----------+------------+-----------------+------------+------------+-----------------------+------------------+------------------+----------------+---------------------+--------------------+--------------+------------+--------------+2 rows in set (0.00 sec)mysql> exit
转载于:https://www.cnblogs.com/persistcat/p/4974750.html
