Page 1 of 4 123 ... LastLast
Results 1 to 10 of 39

Thread: How to.. SQL 13.1/13.2

  1. #1
    Join Date
    Oct 2009
    Location
    Sweden
    Posts
    1,015

    Default How to.. SQL 13.1/13.2

    Hello!
    I use to buy services/consultans to set up this with databases, handle data base managers, connections and so on. I decided during the work week why dont I have a look at it to understand a little more? I mean (The guys at Top Gear UK use to ask "how hard can it be")?

    hw1, my openSUSE server 13.1(uppgraded from 12.x and are on its way to 13.1 Evergreen)
    hw2, my main DE, 13.2
    hw3, my laptop 13.2 (upgraded from 13.1)
    and (havent got there yet) a number of WM's.

    Check upon my server and it had mysql, not mariadb(but the clients have). Not so big deal I think. I mean I use VirtualBox (the oracle version). I start to search om the net and found:
    https://en.opensuse.org/SDB:MySQL_installation

    http://www.linkapps.com/programming/...-opensuse.html among others. I was thinking why do not test with digikam and have the server SQL instance to handle info and thumbnails. According to digikam it has support for mysql (exprimental). Of course my knowledge as a noob on this side made me checked out administrations tools (GUI ones).

    - found that .. checking the tread https://forums.opensuse.org/showthre...-openSuSE-13-1 and went for in on my main 13.2 DE and it give:


    What a heck! Ok. Why not install webadmin that I have used a couple a years ago. Ended up whit the bug https://bugzilla.mozilla.org/show_bug.cgi?id=588479 Still not solved. Installed Chromium and did connect to the webmin after several tries (not using https).

    I got a little bit wiser and could start to see my mysql setup. The tools in webmin was not on my level but I manage to do some things. I hate to get ended with this. Asked my Laptop openSUSE 13.2(upgrade from 13.1) and it suggested the 12.3 package(mysql-workbench) on software.openSUSE.org and 1-click install. Of course I tried. No success. I tried on my 13.1 server as well.. Grrrrr...

    I went to ftp://fr2.rpmfind.net/linux/opensuse/distribution and downloaded mysql-workbench-6.1.7-3.2.7.x86_64.rpm and
    mysql-workbench-5.2.44-2.1.5.x86_64.rpm and installed on different (server(clients)). Works ok on both server and clients but I have a lot to learn and understand. Whenever you readers have stop LOL I asking for some advice:

    -is mysql-workbench the best tool in GUI for a newbie to manage a SQL-database today? Please comment.
    -Later on when I getting a better grip I will transfer to mariadb (I welcome it) to learn even more. Anything special to think on there?

    regards
    I'm shameless like others in the forum -was I to any help or made sense? If yes: click the on the star below to the left. Written whit a ;-) in my eye.

  2. #2
    Join Date
    Nov 2009
    Location
    West Virginia Sector 13
    Posts
    15,768

    Default Re: How to.. SQL 13.1/13.2

    Probably Work bench does all you need to do to administer a DB. You do have to have a basic working understanding of SQL DB administration though. But there is no magic tool that will side step the need to learn some SQL basics.

  3. #3

    Default Re: How to.. SQL 13.1/13.2

    I am using OpenSUSE 13.2 as a server platform for my home and small business server. It is running on an Intel i3 3.0ghz Dual Core with HT, has 6gb of memory and a 500gb main drive, with 6tb of RAID5 storage. The MariaDB (OpenSUSE's choice of MySQL database engine) is pretty painless to set up, and as you have discovered there are many "management" tools out there. I tried several before I decided to use phpMyAdmin mostly because it runs on any platform, is "Noobishly" user friendly and has tons of online resources if help is needed. You may want to pick up a book or two on Linux Administration that cover LAMP, and phpMyAdmin for desk references.

    I also use LibreOffice Base to work with the data, both entry, edit and update as I have created "forms" for data entry. This allows users on my network to safely enter / update data from remote workstations. I have even been able to have one Windows 7 user connect to their own DB files served up by MariaDB (MySQL) via Microsoft Office 2010 Access software. For Base to work with the server, I had to install the MySQL connector extension then log in using the MySQL user created for the purpose of data entry.

    For all of this work (about one weekend of my time) I was quoted between $1500.00us to $4000.00us by four local shops who also wanted to sell me a monthly service plan on top of it. I went with Linux, and OpenSUSE on the recommendations from my local LUG here in Portland, and have never looked back.

    Good luck!

  4. #4
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,454

    Default Re: How to.. SQL 13.1/13.2

    The easiest way to move mysql and mariadb sdatabases is:
    Code:
    mysqldump -u root -p --all-databases > backup.sql
    After you have completed your fresh install:
    Code:
    mysql -u root
    source backup.sql;
    flush privileges;
    Note the absence of a password after the install; obviously you may have a long path to backup.sql.
    You may also have to change the Host in mysql.users since openSUSE normally generates a random hostname during installation which will be different from the hostname of your previous installation.

    Obviously, I am assuming you have a fairly straightforward setup. The mariabd documentation covers all the mysqldump options very well and mariadb recommend this as the way of moving between different versions of mysql and mariadb.

  5. #5
    Join Date
    Dec 2008
    Location
    East of Eden (tx)
    Posts
    331

    Default Re: How to.. SQL 13.1/13.2

    I have a similar problem. I had a localhost server running under openSUSE 12.2. I upgraded to 12.3 and then to 13.1. Somewhere along the way I lost the LAMP server at localhost and all local development websites (I have akeeba backups so they can be restored). I installed Web and LAMP server under 13.1. using instructions at http://en.opensuse.org/SDB:LAMP_setup.

    Now I cannot access the database with phpMyAdmin. I do not know if this is a password problem, if the old mySQL database is still there but inaccessible or if there is something wrong with the new installation. When I run phpMyAdmin, i get their manual only - no database connection - with no password, the old password and the new password I thought I set.

    Sadly, I have fiddled with this not knowing what I am doing and probably made things worse then they need to be.

    How do I fix this? What information do you need to help me?

    Cordially,
    TwoHoot
    #1 - openSUSE Leap 15.1; AMD A6-3670; Radeon(tm) HD; 8gb memory; 500 gb HD; KDE 5.12.8
    #2 - openSUSE Leap 15.1; Toshiba Satellite L70-A (Dual Boot - Win10); KDE 5.12.8
    #3 - openSUSE Leap 15.1; AMD A6-6400K; Radeon HD; 8gb memory; 1tb HD; KDE 5.12.8

  6. #6
    Join Date
    Jun 2008
    Location
    Groningen, Netherlands
    Posts
    20,037
    Blog Entries
    14

    Default Re: How to.. SQL 13.1/13.2

    Check whether mysql is running anyway: Yast - System - Servicesmanager. The mysql service should be enabled and started.
    ° 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
    Dec 2008
    Location
    East of Eden (tx)
    Posts
    331

    Default Re: How to.. SQL 13.1/13.2

    Quote Originally Posted by Knurpht View Post
    Check whether mysql is running anyway: Yast - System - Servicesmanager. The mysql service should be enabled and started.
    Thank you for the prompt reply.

    mysql is active and running in Services Manager

    Cordially,
    TwoHoot
    #1 - openSUSE Leap 15.1; AMD A6-3670; Radeon(tm) HD; 8gb memory; 500 gb HD; KDE 5.12.8
    #2 - openSUSE Leap 15.1; Toshiba Satellite L70-A (Dual Boot - Win10); KDE 5.12.8
    #3 - openSUSE Leap 15.1; AMD A6-6400K; Radeon HD; 8gb memory; 1tb HD; KDE 5.12.8

  8. #8

    Default Re: How to.. SQL 13.1/13.2

    Quote Originally Posted by TwoHoot View Post
    mysql is active and running in Services Manager
    Then you should be able to access it.

    Can you connect using "mysql -u username"?

    Please post the output of "sudo systemctl mysql".

  9. #9
    Join Date
    Dec 2008
    Location
    East of Eden (tx)
    Posts
    331

    Default Re: How to.. SQL 13.1/13.2

    Quote Originally Posted by wolfi323 View Post
    Then you should be able to access it.

    Can you connect using "mysql -u username"?

    Please post the output of "sudo systemctl mysql".
    In Konsol as su,

    mysql -u root yields the following error:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

    sudo systemctl mysql yields the following error:

    Unknown operation 'mysql'.

    Cordially,
    TwoHoot
    #1 - openSUSE Leap 15.1; AMD A6-3670; Radeon(tm) HD; 8gb memory; 500 gb HD; KDE 5.12.8
    #2 - openSUSE Leap 15.1; Toshiba Satellite L70-A (Dual Boot - Win10); KDE 5.12.8
    #3 - openSUSE Leap 15.1; AMD A6-6400K; Radeon HD; 8gb memory; 1tb HD; KDE 5.12.8

  10. #10

    Default Re: How to.. SQL 13.1/13.2

    Quote Originally Posted by TwoHoot View Post
    In Konsol as su,

    mysql -u root yields the following error:
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    Then you have indeed set a password.
    Try "mysql -u root -p" then and enter the password when asked.

    And you don't need to and shouldn't run mysql as root (su).

    sudo systemctl mysql yields the following error:

    Unknown operation 'mysql'.
    It's "sudo systemctl status mysql".
    That "status" somehow got lost in my reply, sorry...

Page 1 of 4 123 ... LastLast

Posting Permissions

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