Skip navigation
Up to Discussions in Openfire Support
5301 Views 7 Replies Latest reply: Apr 27, 2008 2:28 PM by Mike Poole RSS
Mike Poole Bronze
Mike Poole
40 posts since
Apr 21, 2008
Currently Being Moderated

Apr 27, 2008 9:11 AM

MySQL woes

I REALLY hate doing this.

 

Opening up so many threads in a support forum. But, seriously, I would'nt do this if I could'nt find the answer myself. So, please bear with my guys.

Keep in mind I am still a novice at this stuff so most things I do make an honest attempt to look up before asking. Of course anything found always winds up being over my head or nowhere near what I needed(GOOGLE IS NOT THAT HELPFUL*). As stated in another thread I started. I did a clean reinstall of everything. Originally I could'nt get MySQL to properly install for my linux distro until last night. So, its MySQL5.0 running fine. Im able to change the default password and run commands.

 

However I cannot get the MySQL GUI to connect. Following the advice of 1 friend, I removed a line in the my.cnf file called "skip-networking" and STILL I cant get the blasted thing to connect! What else am I missing? Either way I tried looking up the commands to do the import thing of the schema in the Openfire folder manually. The commands provided in the walkthrough do not work for me. What other commands can I use to import that schema since I cant get GUI tools working?

 

Thank you

Tags: mysql, schema, import, gui-tools
  • Coolcat KeyContributor
    Coolcat
    797 posts since
    Mar 19, 2007
    Currently Being Moderated
    Apr 27, 2008 10:26 AM (in response to Mike Poole)
    Re: MySQL woes

    What "MySQL GUI" ? You do not need any GUI.

     

    Login to mysql (if you don't have set a password for database-root account yet, forgot about the "-p" parameter)

    shell> mysql -p -u root

     

    create a new database 'openfire':

    mysql> CREATE DATABASE openfire;

     

    create a new user 'openfire':

    mysql> CREATE USER openfire IDENTIFIED BY 'your-new-password';

     

    Give user 'openfire' only rights for table 'openfire':

    mysql> REVOKE ALL ON *.* FROM openfire;

    mysql> GRANT ALL ON openfire.* TO openfire;

     

    logout

    mysql> exit

     

    import database schema:

    shell> mysql -p -u openfire openfire </opt/openfire/resources/database/openfire_mysql.sql

     

    • Mike Poole Bronze
      Mike Poole
      40 posts since
      Apr 21, 2008
      Currently Being Moderated
      Apr 27, 2008 11:10 AM (in response to Coolcat)
      Re: MySQL woes

      Aw c'mon another one of those "anti gui" things? I thought we lived in the new millenium and long since left the 70's-90's?;) heheh

       

      Thanks either way! Ok, everything was going good till the "</opt/openfire/resources/database/openfire_mysql.sql" part.

       

      Was that supposed to be all in 1 command? If so, its not working. I keep getting hit with an: bash: /opt/openfire/resources/database/openfire_mysql.sql: Permission denied error.

       

      BTW: I am using a different name for the created DB & user. The steps all remained the same and no errors on each one. Its just that one which I believe is for copying over that schema thats not going through.

      • winsrev KeyContributor
        winsrev
        270 posts since
        Jan 28, 2007
        Currently Being Moderated
        Apr 27, 2008 11:18 AM (in response to Mike Poole)
        Re: MySQL woes

        Means that the mysql user did not have enough permissions to create new tables and such, might want to try and use root or something.

        • Mike Poole Bronze
          Mike Poole
          40 posts since
          Apr 21, 2008
          Currently Being Moderated
          Apr 27, 2008 12:17 PM (in response to winsrev)
          Re: MySQL woes

          Tried it as root. Same error. Unless you mean "system root"?

          • Mike Poole Bronze
            Mike Poole
            40 posts since
            Apr 21, 2008
            Currently Being Moderated
            Apr 27, 2008 1:01 PM (in response to Mike Poole)
            Re: MySQL woes

            Hey!

             

            I su'ed to root and BOOM, it worked! 0.o

            Not sure if this is the sign of issues to come if everything I need to do is gonna require me becoming system root to do things that should be user level.

             

            Well, either way Winserv & Coolcat. GOOD LOOKING OUT!

            Thank you both of ya!

            • Coolcat KeyContributor
              Coolcat
              797 posts since
              Mar 19, 2007
              Currently Being Moderated
              Apr 27, 2008 2:04 PM (in response to Mike Poole)
              Re: MySQL woes

              bash: /opt/openfire/resources/database/openfire_mysql.sql: Permission denied error.

              seems like your user had not the permission to read that file

               

              Offtopic:

              thought we lived in the new millenium and long since left the 70's-90's?;)

              If you know all the shortcuts (Tab, Strg+R, Cursorkeys, ...) and small helper tools you can work MUCH faster using console. Especially if you are working remote using SSH.

              • Mike Poole Bronze
                Mike Poole
                40 posts since
                Apr 21, 2008
                Currently Being Moderated
                Apr 27, 2008 2:28 PM (in response to Coolcat)
                Re: MySQL woes

                >thought we lived in the new millenium and long since left the 70's-90's?;)

                If you know all the shortcuts (Tab, Strg+R, Cursorkeys, ...) and small helper tools you can work MUCH faster using console. Especially if you are working remote using SSH. <

                 

                Heh, I know. Its just that its such an age old argument. You're looking at a guy that could care less which to use but still goes for the "visual" if given a choice. Hey, Im a graphic artist. Im a visual guy by nature^^. So, if there's a viable graphical choice available, of course I'll gun for it everytime. The whole argument if you ask me is all about "personal prefs". Because both sides will battle to the end of eternity as to which is more practical =\

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points