MySQL
今天也要学习呀~
这个作者很懒,什么都没留下…
展开
-
MySQL增删改查常用命令
增:insert删:delete改:update查:show或select连接数据库mysql -h[主机地址] -u[用户名] -p[用户密码]修改密码mysqladmin -u[用户名] -p[旧密码] -password[新密码]增加新用户grant select on 数据库. * to 用户名@登录主机 identified by /“密码/”;windows启动MySQLnet start mysql虚拟机启动MySQLservice start mysq原创 2021-03-29 16:43:57 · 1021 阅读 · 4 评论 -
虚拟机查看MySQL端口号
先进入MySQLmysql -hhadoop102 -uroot -p再查看端口号show variables like ‘port’;原创 2021-03-29 09:28:24 · 1788 阅读 · 0 评论 -
Cannot connect to “localhost“. The server time zone value ‘�й���ʱ��‘ is unrecognized or represents
Cannot connect to “localhost”.The server time zone value ‘�й���ʱ��’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the ‘serverTimezone’ configuration property) to use a more specifc time zo原创 2021-03-26 15:16:30 · 3495 阅读 · 4 评论