Profile cover photo
Profile photo
Golden john
117 followers -
Never Back Down
Never Back Down

117 followers
About
Posts

Post has attachment
How to install the mysql 8.0 version in centos 6


Open the repository file and put the entry , and follow the procedure which is done.





[root@server1 ~]# vim /etc/yum.repos.d/mysql-community
mysql-community.repo mysql-community-source.repo
[root@server1 ~]# vim /etc/yum.repos.d/mysql-community.repo


[root@server1 ~]# cat /etc/yum.repos.d/mysql-community.repo


# Enable to use MySQL 8.0
[mysql80-community]
name=MySQL 8.0 Community Server
baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/6/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql


[root@server1 ~]# yum repolist enabled | grep mysql
mysql-connectors-community MySQL Connectors Community 24
mysql-tools-community MySQL Tools Community 42
mysql56-community MySQL 5.6 Community Server 316
mysql80-community MySQL 8.0 Community Server 17
[root@server1 ~]# yum install mysql-community-server
Loaded plugins: fastestmirror, protectbase, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
* base: centosmirror.go4hosting.in
* extras: centos-hn.viettelidc.com.vn
* remi: mirror.h1host.ru
* remi-safe: mirror.h1host.ru
* rpmforge: ftp.heanet.ie
* updates: centos-hcm.viettelidc.com.vn
* webtatic: uk.repo.webtatic.com
0 packages excluded due to repository protections
Resolving Dependencies
--> Running transaction check
-> Package mysql-community-server.x86_64 0:5.6.32-2.el6 will be updated
-> Package mysql-community-server.x86_64 0:8.0.0-0.1.dmr.el6 will be an update
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.0-0.1.dmr.el6 for package: mysql-community-server-8.0.0-0.1.dmr.el6.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.0 for package: mysql-community-server-8.0.0-0.1.dmr.el6.x86_64
--> Running transaction check
-> Package mysql-community-client.x86_64 0:5.6.34-2.el6 will be updated
-> Package mysql-community-client.x86_64 0:8.0.0-0.1.dmr.el6 will be an update
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.0 for package: mysql-community-client-8.0.0-0.1.dmr.el6.x86_64
-> Package mysql-community-common.x86_64 0:5.6.32-2.el6 will be updated
-> Package mysql-community-common.x86_64 0:8.0.0-0.1.dmr.el6 will be an update
--> Running transaction check
-> Package mysql-community-libs.x86_64 0:5.6.32-2.el6 will be updated
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: mysql-community-devel-5.6.32-2.el6.x86_64
-> Package mysql-community-libs.x86_64 0:8.0.0-0.1.dmr.el6 will be an update
--> Running transaction check
-> Package mysql-community-devel.x86_64 0:5.6.32-2.el6 will be updated
-> Package mysql-community-devel.x86_64 0:8.0.0-0.1.dmr.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

========================================================================================================================================================================
Package Arch Version Repository Size
========================================================================================================================================================================
Updating:
mysql-community-server x86_64 8.0.0-0.1.dmr.el6 mysql80-community 196 M
Updating for dependencies:
mysql-community-client x86_64 8.0.0-0.1.dmr.el6 mysql80-community 27 M
mysql-community-common x86_64 8.0.0-0.1.dmr.el6 mysql80-community 335 k
mysql-community-devel x86_64 8.0.0-0.1.dmr.el6 mysql80-community 4.2 M
mysql-community-libs x86_64 8.0.0-0.1.dmr.el6 mysql80-community 2.5 M

Transaction Summary
========================================================================================================================================================================
Upgrade 5 Package(s)

Total download size: 230 M
Is this ok [y/N]: y
Downloading Packages:
(1/5): mysql-community-client-8.0.0-0.1.dmr.el6.x86_64.rpm | 27 MB 00:20
(2/5): mysql-community-common-8.0.0-0.1.dmr.el6.x86_64.rpm | 335 kB 00:00
(3/5): mysql-community-devel-8.0.0-0.1.dmr.el6.x86_64.rpm | 4.2 MB 00:04
(4/5): mysql-community-libs-8.0.0-0.1.dmr.el6.x86_64.rpm | 2.5 MB 00:03
(5/5): mysql-community-server-8.0.0-0.1.dmr.el6.x86_64.rpm | 196 MB 02:40
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 1.2 MB/s | 230 MB 03:12
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : mysql-community-common-8.0.0-0.1.dmr.el6.x86_64 1/10
Updating : mysql-community-libs-8.0.0-0.1.dmr.el6.x86_64 2/10
Updating : mysql-community-client-8.0.0-0.1.dmr.el6.x86_64 3/10
Updating : mysql-community-server-8.0.0-0.1.dmr.el6.x86_64 4/10
warning: /etc/my.cnf created as /etc/my.cnf.rpmnew
Updating : mysql-community-devel-8.0.0-0.1.dmr.el6.x86_64 5/10
Cleanup : mysql-community-devel-5.6.32-2.el6.x86_64 6/10
Cleanup : mysql-community-server-5.6.32-2.el6.x86_64 7/10
Cleanup : mysql-community-client-5.6.34-2.el6.x86_64 8/10
Cleanup : mysql-community-libs-5.6.32-2.el6.x86_64 9/10
Cleanup : mysql-community-common-5.6.32-2.el6.x86_64 10/10
Verifying : mysql-community-common-8.0.0-0.1.dmr.el6.x86_64 1/10
Verifying : mysql-community-devel-8.0.0-0.1.dmr.el6.x86_64 2/10
Verifying : mysql-community-server-8.0.0-0.1.dmr.el6.x86_64 3/10
Verifying : mysql-community-libs-8.0.0-0.1.dmr.el6.x86_64 4/10
Verifying : mysql-community-client-8.0.0-0.1.dmr.el6.x86_64 5/10
Verifying : mysql-community-common-5.6.32-2.el6.x86_64 6/10
Verifying : mysql-community-devel-5.6.32-2.el6.x86_64 7/10
Verifying : mysql-community-libs-5.6.32-2.el6.x86_64 8/10
Verifying : mysql-community-client-5.6.34-2.el6.x86_64 9/10
Verifying : mysql-community-server-5.6.32-2.el6.x86_64 10/10

Updated:
mysql-community-server.x86_64 0:8.0.0-0.1.dmr.el6

Dependency Updated:
mysql-community-client.x86_64 0:8.0.0-0.1.dmr.el6 mysql-community-common.x86_64 0:8.0.0-0.1.dmr.el6 mysql-community-devel.x86_64 0:8.0.0-0.1.dmr.el6
mysql-community-libs.x86_64 0:8.0.0-0.1.dmr.el6

Complete!



Thanks for viewing enjoy the Mysql 8.0
Add a comment...

Post has attachment

Post has attachment
MySQL commands for Database Administration in Linux
1. How to set MySQL Root password? If you have fresh installation of MySQL server,
then it doesn’t required any password to connect it as root user. To set MySQL
password for root user, use the following command. # mysqladmin -u root password YOURNEWPASSWOR...
Add a comment...

Post has attachment
How to install Asterisk on CentOS 7.X
In this
installment of our How To, we are going to go over on the topic of how to
install   Asterisk  on   CentOS .
For this we are going to use Asterisk 13 and CentOS 7   minimal   version. But, instructions will mostly
be similar to other versions of Aste...
Add a comment...

Post has attachment

Post has attachment
MySQL Backup and Restore Commands for Database Administration
How
to Backup MySQL Database? To take a backup of MySQL database or databases, the database must exist in the database server and you
must have access to it. The format of the command would be. #
mysqldump -u [username] –p[password] [database_name] > [dump_...
Add a comment...

Post has attachment

Post has attachment
System Clock Set back detected
Login as root user. Check date and modify as 20/03/2016 # date 032010202016  [mmddhhmmyyyy] to change date #hwclock   --systohc   to change hw clock time # date to check the date change or not Thanks for  the visit .
Add a comment...

Post has attachment

Post has attachment
Perform SSH Login Without Password Using ssh-keygen & ssh-copy-id
Step 1: Create public and private keys
using ssh-key-gen on local-host goldenjohn@local-host$ [Note: You are on
local-host here] goldenjohn@local-host$ ssh-keygen Generating public/private rsa key pair. Enter file in which to save the key
(/home/goldenjohn/...
Add a comment...
Wait while more posts are being loaded