wordpress又出了点问题。就是发布文章的时候没有显示在我的主页上。但是在文章的分类中我还是可以查看到了 所以我想使用 mysql来把数据库重新做过没有办法 谁叫我是菜鸟呢.
安装了 yum就没有这样的费力了
code—————————-
[root@jlinux ~]# yum install mysql-client
Loading “installonlyn” plugin
Existing lock /var/run/yum.pid: another copy is running. Aborting.
很多的时候都会遇到这样的情况。原因很简单 yum是允许同一时间只能有一个进程运行 原理知道了
我就
code——————————–
[root@jlinux ~]# rm -f /var/run/yum.pid
把/var/run/yum.pid给删除了 这样就可以使用了所以以后使用yum的时候一定要正确的退出 而不是ctrl+c
[1/4]
core [2/4]
updates [3/4]
extras [4/4]
Reading repository metadata in from local files
Parsing package install arguments
Resolving Dependencies
–> Populating transaction set with selected packages. Please wait.
—> Downloading header for mysql to pack into transaction set.
mysql-5.0.27-1.fc5.i386.r 100% |=========================| 35 kB 00:01
—> Package mysql.i386 0:5.0.27-1.fc5 set to be updated
–> Running transaction check
–> Processing Dependency: perl(DBI) for package: mysql
–> Restarting Dependency Resolution with new changes.
–> Populating transaction set with selected packages. Please wait.
—> Downloading header for perl-DBI to pack into transaction set.
perl-DBI-1.52-1.fc5.i386. 100% |=========================| 16 kB 00:00
—> Package perl-DBI.i386 0:1.52-1.fc5 set to be updated
–> Running transaction check
Dependencies Resolved
=============================================================================
Package Arch Version Repository Size
=============================================================================
Installing:
mysql i386 5.0.27-1.fc5 updates 3.3 M
Installing for dependencies:
perl-DBI i386 1.52-1.fc5 updates 605 k
Transaction Summary
=============================================================================
Install 2 Package(s)
Update 0 Package(s)
Remove 0 Package(s)
Total download size: 3.9 M
Is this ok [y/N]: y
Downloading Packages:
(1/2): mysql-5.0.27-1.fc5 100% |=========================| 1.8 MB 02:18
http://ftp.iij.ad.jp/pub/linux/fedora/core/updates/5/i386/mysql-5.0.27-1.fc5.i386.rpm: [Errno 4] Socket Error: (11, ‘\xe8\xb5\x84\xe6\xba\x90\xe6\x9a\x82\xe6\x97\xb6\xe4\xb8\x8d\xe5\x8f\xaf\xe7\x94\xa8′)
Trying other mirror.
(1/2): mysql-5.0.27-1.fc5 100% |=========================| 3.3 MB 06:17
(2/2): perl-DBI-1.52-1.fc 100% |=========================| 605 kB 01:37
———————————–
下载了 mysql and perl-dbi两个包。。
不知道是原因下载了 这两个包 但是并没有安装 。。
我就来到了 yum的cache目录 ／var/cache/yum
我的fedora 5上面有 core extras fedora-xgl livna updates
这样的目录
core就是必要的软件 extras是额外的 附加的意思 feodra-xgl这个是我以前安装xgl桌面的时候建立的 livna有很多使用的软件 updates就是mysql的包的存放的目录了 。。。
code———————————-
[root@jlinux packages]# pwd
/var/cache/yum/updates/packages
[root@jlinux packages]# rpm -ivh mysql-5.0.27-1.fc5.i386.rpm
Preparing… ########################################### [100%]
package mysql-5.0.27-1.fc5 is already installed
[root@jlinux packages]# rpm -ivh perl-DBI-1.52-1.fc5.i386.rpm
Preparing… ########################################### [100%]
package perl-DBI-1.52-1.fc5 is already installed
[root@jlinux packages]#
code———————————————–
安装这两个包
但是安装mysql并没有成功
#mysql -h jlinux -u sq_tunpishuang -p
连接的时候显示
code——————————–
[root@jlinux ~]# mysql -h jlinux.cn -u sq_tunpishuang -p
Enter password:
ERROR 1045 (28000): Access denied for user ’sq_tunpishuang’@'222.183.62.123′ (using password: YES)
[root@jlinux ~]#
code———————————–
解决了 是我的密码错了 呵呵
看到以下的东西就是我们已经成功的进入的MYSQL的 数据库系统
真的是很对不起大家 我用的空间是windows下面的mysql..呵呵 linux 那些都很贵 不是linux的优点是成本低啊
其实不是这样 linux的发行版确实是很便宜 但是犹豫linux的复杂度高 所以网管的工资高了费用当然就高了哦
下面是连接成功的样子 ：
code———————————
[root@jlinux ~]# mysql -h 125.65.81.5 -u sq_tunpishuang -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 77045 to server version: 5.2.3-falcon-alpha-communit y-nt
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql>
——————————————————–
[root@jlinux ~]# mysql -h jlinux.cn -u sq_tunpishuang -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 77149 to server version: 5.2.3-falcon-alpha-community-nt
Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the buffer.
mysql> select version()
-> select version()
-> selet current_dat
-> selet current_data
-> selet current_data
-> selet current_data;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’select version()
selet current_dat
selet current_data
selet current_data
selet c’ at line 2
mysql> use sq_tunpishuang
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
-> show tables;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’show tables’ at line 2
mysql> show table
-> show table;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ’show table’ at line 2
mysql> show tables;
+————————–+
| Tables_in_sq_tunpishuang |
+————————–+
| wp_categories |
| wp_comments |
| wp_link2cat |
| wp_links |
| wp_options |
| wp_post2cat |
| wp_postmeta |
| wp_posts |
| wp_sticky |
| wp_usermeta |
| wp_users |
+————————–+
11 rows in set (0.05 sec)
mysql>
可以看到很多的表格了 呵呵
wp_表示我用的是wordpress的php程序；
然后就开始重新作站了
