Skip to main content

Updating mysql 5.5 to mysql mysql 5.7



Copy the following commands in terminal and run them:

wget https://dev.mysql.com/get/mysql-apt-config_0.8.1-1_all.deb

sudo dpkg -i mysql-apt-config_0.8.1-1_all.deb






You'll see a prompt that asks you which MySQL product you want to configure. 
The MySQL Server option, which is highlighted, should say mysql-5.7.
If it doesn't, press ENTER, then scroll down to mysql-5.7 using the arrow keys, and press ENTER again,now scroll down and select OK and ENTER




sudo apt-get update


sudo apt-get install mysql-server




sudo mysql_upgrade -u root -p




 sudo service mysql restart









































Comments









  1. yaelcadena5 March 2022 at 23:17
    sugarboo extra long digital titanium styler
    Ingredients: sugar, pineapple, sugar and salt. Packed with sugar, a sweet taste, titan metal made 2016 ford fusion energi titanium with head titanium tennis racket pure habanero chile revlon titanium max edition powder, pineapple, gold titanium alloy lime juice, garlic, and
    ReplyDelete











Post a Comment






























Popular posts from this blog



















Send Email(with subject,body,attachment) using SSMTP through Terminal in linux?




























     1.Install ssmtp as                 $ sudo apt-get update && sudo apt-get install ssmtp     2.Configure smtp file by editing the following file as,    $ sudo gedit /etc/ssmtp/ssmtp.conf   Update file with the following:   AuthUser=Sendermail@gmail.com   AuthPass=SenderPasswordforGMAIL   FromLineOverride=YES   mailhub=smtp.gmail.com:587   UseSTARTTLS=YES   Now ssmtp.conf file should look like as the following one,   AuthUser=Sendermail@gmail.com   AuthPass=SenderPasswordforGMAIL   #   # Config file for sSMTP sendmail   #   # The person who gets all mail for userids < 1000   # Make this empty to disable rewriting.   root=postmaster   # The place where the mail goes. The actual machine name is required no   # MX records are consulted. Commonly mailhosts are named mail.domain.com   mailhub=smtp.gmail.com:587   # Where will the mail seem to come from?   #rewriteDomain=   # The full hostname   hostname=tele-desktop118   # Are users allowed to set their own From: address?   # Y




















1 comment









Read more




























Backup (or) Download MYSQL Database as a zip file Using PHP




























 NOTE:Please change below credentials  with respect to your Database and Run the file.   <?php  define ( "DB_USER" ,  'DatabaseUSERNAME' ); define ( "DB_PASSWORD" ,  'DatabasePASSWORD' ); define ( "DB_NAME" ,  'DatabaseNAME' ); define ( "DB_HOST" ,  'localhost' ); define ( "BACKUP_DIR" ,  'myphp-backup-files' );  // Comment this line to use same script's directory ('.') define ( "TABLES" ,  '*' );  // Full backup //define("TABLES", 'table1, table2, table3'); // Partial backup of required tables define ( "CHARSET" ,  'utf8' ); define ( "GZIP_BACKUP_FILE" ,  true );   // Set to false if you want plain SQL backup files (not gzipped) class  Backup_Database {     var  $host ;     var  $username ;     var  $passwd ;     var  $dbName ;     var  $charset ;     var  $conn ;     var  $backupDir ;     var  $backupFile ;     var  $




















1 comment









Read more




























Upload and Retrieve an image from database




























 /*Create table in sql:*/   CREATE TABLE `images` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `image` longblob NOT NULL,  `created` datetime NOT NULL,  PRIMARY KEY (`id`)  );    /*Uploading an image to Database*/   <?php  if ( isset ( $_POST [ "submit" ])){      $check = getimagesize ( $_FILES [ "image" ][ "tmp_name" ]);      if ( $check !== false ){          $image = $_FILES [ 'image' ][ 'tmp_name' ];          $imgContent = addslashes ( file_get_contents ( $image ));           $dbHost = 'localhost' ;          $dbUsername = 'root' ;          $dbPassword = 'root' ;          $dbName = 'sample' ;   //Create connection and select DB          $db = new mysqli( $dbHost , $dbUsername , $dbPassword , $dbName );   // Check connection          if ( $db -> connect_error ){              die ( "Connection failed: " . $db -> connect_error );          }           $dateTime = date ( "Y-m-d H:i:s" )




















Post a Comment









Read more