How to install mysql?

  • I tried mysql in my command line :

    I get:

    The program 'mysql' is currently not installed.  You can install it by typing:
    sudo apt-get install mysql-client-core-5.5
    

    But when I do:

    sudo apt-get install mysql-client-core-5.5
    

    But I get:

    Reading package lists... Done
    Building dependency tree       
    Reading state information... Done
    mysql-client-core-5.5 is already the newest version.
    0 upgraded, 0 newly installed, 0 to remove and 47 not upgraded.
    

    How should I proceed?

    What does `ls -l /usr/bin/mysql` say?

    This is what I got `ls: cannot access /usr/bin/mysql: No such file or directory`, when I do `ls -l /usr/bin/mysql`

    Try `sudo apt-get --reinstall install mysql-client-core-5.5`

  • First, remove the current version of MySQL you're already using:

    $ sudo apt-get purge mysql-client-core-5.5
    

    Now, to install MySQL, run the following command from a terminal prompt:

    $ sudo apt-get install mysql-server
    $ sudo apt-get install mysql-client
    

    During the installation process you will be prompted to enter a password for the MySQL root user.

    Once the installation is complete, the MySQL server should be started automatically. You can run the following command from a terminal prompt to check whether the MySQL server is running:

    $sudo netstat -tap | grep mysql
    

    When you run this command, you should see the following line or something similar:

    tcp        0      0 localhost.localdomain:mysql           *:* LISTEN -
    

    If the server is not running correctly, you can type the following command to start it:

    $ sudo /etc/init.d/mysql restart
    

    You can edit the /etc/mysql/my.cnf file to configure the basic settings: log file, port number, etc.

    @batman we are expecting some reply from you or at least a `verified` marking

    most of this answer appears to be cut and paste from https://help.ubuntu.com/12.04/serverguide/mysql.html

  • This command installs the MySQL server, which you need.

    sudo apt-get install mysql-server
    

    If you want to run commands from the workbench and not from a terminal, you need the client as well (this is optional):

    sudo apt-get install mysql-client
    

    For MySQL Workbench (also optional):

    sudo apt-get install mysql-workbench
    
  • First you have to remove mysql completely from your system using following commands in terminal

    sudo apt-get remove --purge mysql-server mysql-client mysql-common

    sudo apt-get update && sudo apt-get upgrade

    sudo apt-get autoremove

    sudo apt-get autoclean

    Now try to reinstall Mysql.

  • That suggestion seems a little bizzare because it would miss out other dependencies and utilities. I would just run this and be done with it:

    sudo apt-get install mysql-client
    

License under CC-BY-SA with attribution


Content dated before 6/26/2020 9:53 AM