MySQL基本操作

最新推荐文章于 2021-06-17 12:06:01 发布

csdn11223

最新推荐文章于 2021-06-17 12:06:01 发布

阅读量38

点赞数

文章标签：数据库

本文介绍了在Red Hat系统中启动和管理MySQL服务的过程。包括通过mysqld_safe命令启动MySQL服务，使用mysqladmin命令进行关闭操作，并展示了如何连接到MySQL服务器及查看数据库与表的基本操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[mysql@redhat ~]$ cat .my.cnf
[mysql]
user=root
password=root
[mysqld]
datadir=/mysql/mysql-5.0.41-linux-i686/data
[mysql@redhat ~]$ cd /mysql/mysql-5.0.41-linux-i686
[mysql@redhat mysql-5.0.41-linux-i686]$ cd bin
[mysql@redhat bin]$ ./mysqld_safe &
[1] 3316
[mysql@redhat bin]$ Starting mysqld daemon with databases from /mysql/mysql-5.0.41-linux-i686/data
logout
[root@redhat bin]# su - mysql

Good Luck!!

[mysql@redhat ~]$ cd /mysql/mysql-5.0.41-linux-i686/bin
[mysql@redhat bin]$ ./mysqladmin -uroot -proot shutdown
STOPPING server from pid file /var/run/mysqld/mysqld.pid
080118 22:10:49 mysqld ended

[mysql@redhat bin]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[mysql@redhat bin]$ ./mysql_safe &
[1] 3391
-bash: ./mysql_safe: No such file or directory
[mysql@redhat bin]$ ./mysqld_safe &
[2] 3392
[1] Exit 127 ./mysql_safe
[mysql@redhat bin]$ Starting mysqld daemon with databases from /mysql/mysql-5.0.41-linux-i686/data

[mysql@redhat bin]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.41

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use law
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables
    -> ;
+---------------------+
| Tables_in_law |
+--------------------+
| t                          |
| tt                         |
+--------------------+
2 rows in set (0.01 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/37724/viewspace-152667/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/37724/viewspace-152667/