Results 1 to 9 of 9

Thread: MySql does not work

  1. #1
    Join Date
    Aug 2013
    Location
    Jundiai, São Paulo, Brazil
    Posts
    467

    Default MySql does not work

    I'm using OpenSuse 12.3 32 and KDE

    I'm trying to use MySQL, but this is the result
    LinuxCasa:/home/sergio # mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
    What should I do?

  2. #2
    Join Date
    Jun 2008
    Location
    Netherlands
    Posts
    25,157

    Default Re: MySql does not work

    Did you do anything to start the mysql server? Or do you think it is running by magic?
    Henk van Velden

  3. #3
    Join Date
    Aug 2013
    Location
    Jundiai, São Paulo, Brazil
    Posts
    467

    Default Re: MySql does not work

    Quote Originally Posted by hcvv View Post
    Did you do anything to start the mysql server? Or do you think it is running by magic?
    I'm following instructions of the Site:
    http://www.zoneminder.com/wiki/index.php/Documentation#Installation_from_Source

    Installation from Source

    For a new installation the next thing you will need to do is create your database and database users. So type the commands as follows when in the folder of the extracted zm files,

    Create the ZoneMinder database 'zm' and populate it with the tables for ZoneMinder:
    $ mysql
    mysql> create database zm;
    mysql> exit;
    $ mysql zm < db/zm_create.sql <This file doesn't exist until after 'make'>
    You mean they are wrong?
    So, why "$ mysql" seems works for them?

  4. #4

    Default Re: MySql does not work

    Quote Originally Posted by sergelli View Post
    I'm following instructions of the Site:
    http://www.zoneminder.com/wiki/index.php/Documentation#Installation_from_Source



    You mean they are wrong?
    So, why "$ mysql" seems works for them?
    Assuming you started mysql server (using systemctl or /etc/init.d/mysql), those commands should work.

    You're also not supposed to type the dollar sign ($). The sign just indicates terminal prompt. So the first command should just be "mysql".

  5. #5
    Join Date
    Aug 2013
    Location
    Jundiai, São Paulo, Brazil
    Posts
    467

    Default Re: MySql does not work

    Quote Originally Posted by mdchaudhari View Post
    Assuming you started mysql server (using systemctl or /etc/init.d/mysql), those commands should work. You're also not supposed to type the dollar sign ($). The sign just indicates terminal prompt. So the first command should just be "mysql".
    I tryed use the "/etc/init.d/mysql start"
    linux-l78t:/home/sergio # /etc/init.d/mysql start redirecting to systemctl start mysql linux-l78t:/home/sergio # mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 1 Server version: 5.5.33-MariaDB openSUSE package Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]>
    Now it seems worked, but what is the "MariaDB" ? This does the same job?

  6. #6
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    19,853
    Blog Entries
    14

    Default Re: MySql does not work

    Quote Originally Posted by sergelli View Post
    I tryed use the "/etc/init.d/mysql start" Now it seems worked, but what is the "MariaDB" ? This does the same job?
    MariaDB is a fork of mysql, initiated when Oracle took over Sun and was on the path of closing development, changing licenses etc. AFAIK the founder of mysql forked it himself.
    ° Appreciate my reply? Click the star and let me know why.

    ° Perfection is not gonna happen. No way.

    https://en.opensuse.org/openSUSE:Board#Members
    http://en.opensuse.org/User:Knurpht
    http://nl.opensuse.org/Gebruiker:Knurpht

  7. #7
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: MySql does not work

    MariaDB is a drop in replacement for MySQL up to version 5.5.n; for compatibility, it uses exactly the same commands as MySQL.

  8. #8
    Join Date
    Aug 2013
    Location
    Jundiai, São Paulo, Brazil
    Posts
    467

    Default Re: MySql does not work

    Quote Originally Posted by john_hudson View Post
    MariaDB is a drop in replacement for MySQL up to version 5.5.n; for compatibility, it uses exactly the same commands as MySQL.
    I tried using Mysql, but my real goal was to try to install the "zoneminder", a software that manages IP cameras, and it uses Mysql.
    However, this software is full of difficulties for my little knowledge and I'm giving it ...

    So I'm very grateful for information about MySql
    If anyone knows anything about IP cameras with Linux, please let me know.

    Thanks

  9. #9

    Default Re: MySql does not work

    Quote Originally Posted by sergelli View Post
    If anyone knows anything about IP cameras with Linux, please let me know.
    Normally you should be able to connect to the IP camera by just entering the IP address in your web browser. This should work in Linux as well.

    Other than that, I guess you should describe what you actually want to do. And the model of your camera would help as well.
    But better start a new thread for this, I'd say, since this has nothing to do with mysql anymore.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •