mysql 数据库问题_mysql数据库问题

一，给root用户添加密码

遇到的问题

/usr/local/mysql5/bin/mysqladmin -u root -p password root

Enter password:

/usr/local/mysql5/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

问题2

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

二，通过终端链接seqserver

/usr/local/mysql/bin/mysql -u root -p

三，通过终端启动或关闭mysql

1.sudo/Library/StartupItems/MySQLCOM/MySQLCOM start

2.sudo/Library/StartupItems/MySQLCOM/MySQLCOM stop

sudo/Library/StartupItems/MySQLCOM/MySQLCOM [start |stop | restart]

四，解决方案

卸载，重装。5.7.

cd /usr/local/mysql/bin

./mysql -u root -p

enter password:自动生成的密码输入

进入数据库

SET PASSWORD = PASSWORD('root');

新建数据库

create database cAuth；

完美解决以上问题。

五

mysql -u root -p;

use cAuth;

show tables;

create database test;

select * from cSessionInfo;

建表

create table test(id int,name varchar(100));

查看表

select * from test;

show tables;

desc cSessionInfo;

select create_time,open_id from cSessionInfo;

删除表

show tables;

drop table test;

npm install wafer2-client-sdk --save

npm install sass-loader node-sass -save-dev