SEO

When you install Mysql with yast it creates lots of mysql directories.
Which directory is the database directory?


--
Blattus Slafaly ? 3 7/8

Blattus Slafaly 0/00 ? ? ? wrote:

> When you install Mysql with yast it creates lots of mysql directories.
> Which directory is the database directory?
>
>

If you mean 'where is the actual data stored' then it
is /var/lib/mysql/'your-application-database-name'. If you want to know
where the configuration files are stored it is /usr/share/mysql. However,
the 'main' configuration file is /etc/mysql.cnf

At least that's my 'observation'...

Michael Soibelman wrote:
> Blattus Slafaly 0/00 ? ? ? wrote:
>
>> When you install Mysql with yast it creates lots of mysql directories.
>> Which directory is the database directory?
>>
>>
>
> If you mean 'where is the actual data stored' then it
> is /var/lib/mysql/'your-application-database-name'. If you want to know
> where the configuration files are stored it is /usr/share/mysql. However,
> the 'main' configuration file is /etc/mysql.cnf
>
> At least that's my 'observation'...

Why ain't there a GUI interface to operate the piece of crap? You have
to do all this secret back door crap to get this thing working.

--
Blattus Slafaly ? 3 7/8

Blattus Slafaly 0/00 ? ? ? wrote:

> Michael Soibelman wrote:
>> Blattus Slafaly 0/00 ? ? ? wrote:
>>
>>> When you install Mysql with yast it creates lots of mysql directories.
>>> Which directory is the database directory?
>>>
>>>
>>
>> If you mean 'where is the actual data stored' then it
>> is /var/lib/mysql/'your-application-database-name'. If you want to know
>> where the configuration files are stored it is /usr/share/mysql.
>> However, the 'main' configuration file is /etc/mysql.cnf
>>
>> At least that's my 'observation'...
>
> Why ain't there a GUI interface to operate the piece of crap? You have
> to do all this secret back door crap to get this thing working.
>

Well there is a GUI for MySQL ! Try not being such a crapy mouth if you
want help though. I'll just take it to mean you're frustrated though and
I'll try to help you.

Install:

1. mysql-administrator
2. mysql-query-browser
3. mysql-gui (needed by #2)

P.S. If you want to 'see' where all your installed rpm's files are I
recommend installing 'xrpm-2.2-3', which you can get here: (shift + left
click to download !!)

ftp://ftp.kddlabs.co.jp/pub/Linux/pa...2-3.noarch.rpm

Newer versions have dependency issues in my experience. Also, do NOT use
this package as root as this package does not work well Yast's data
base !!!! But it is, in my experience, the fastest way to see all the
installed rpm's with a nice gui interface. Just expand the program to top
and bottom of your screen by dragging the edges to make the slider bar
bigger as this makes it easier to move up and down in the gui. Click on
the application you are looking for and then click on the 'list files'
button to see every file associated with the application...

Chill out man !!

On 2008-03-27, Blattus Slafaly 0/00 ? ? ? <boobooililililil@roadrunner.com> wrote:
> Michael Soibelman wrote:
>> Blattus Slafaly 0/00 ? ? ? wrote:
>>
>>> When you install Mysql with yast it creates lots of mysql directories.
>>> Which directory is the database directory?
>>>
>>>
>>
>> If you mean 'where is the actual data stored' then it
>> is /var/lib/mysql/'your-application-database-name'. If you want to know
>> where the configuration files are stored it is /usr/share/mysql. However,
>> the 'main' configuration file is /etc/mysql.cnf
>>
>> At least that's my 'observation'...
>
> Why ain't there a GUI interface to operate the piece of crap? You have
> to do all this secret back door crap to get this thing working.
>

So you know nothing and you call MySQL that?
I don't know much but I'd call it anything else than that, you.

You are something.

Just in case you learn to behave in the _very_ near future:

http://www.phpmyadmin.net/home_page/index.php


And FYI that GUI is included in openSUSE.

P.S. Try that behavior in MySQL or php groups...

Vahis
--
“The greatest ignorance is to reject something you know nothing about”.

On 2008-03-27 22:38, Blattus Slafaly 0/00 ? ? ? wrote:
> Michael Soibelman wrote:
>> Blattus Slafaly 0/00 ? ? ? wrote:
>>
>>> When you install Mysql with yast it creates lots of mysql directories.
>>> Which directory is the database directory?
>>>
>>>
>>
>> If you mean 'where is the actual data stored' then it
>> is /var/lib/mysql/'your-application-database-name'. If you want to know
>> where the configuration files are stored it is /usr/share/mysql.
>> However,
>> the 'main' configuration file is /etc/mysql.cnf
>>
>> At least that's my 'observation'...
>
> Why ain't there a GUI interface to operate the piece of crap? You have
> to do all this secret back door crap to get this thing working.
>

The secrets are to read instructions.

Just do rcmysql start and it TELL YOU what to do.
Set the password for root and root@yourhost.domain

Create the file /root/.my.cnf , make it readable only for root.
add:

[client]
user = root
password = 'the password for root'


Now you can do mysqlshow , mysqladmin, mysql , mysqldump without passwords and
things as root.

and install mysql-administrator from mysql.com if you need a GUI.

/bb

Vahis wrote:
> On 2008-03-27, Blattus Slafaly 0/00 ? ? ? <boobooililililil@roadrunner.com> wrote:
>> Michael Soibelman wrote:
>>> Blattus Slafaly 0/00 ? ? ? wrote:
>>>
>>>> When you install Mysql with yast it creates lots of mysql directories.
>>>> Which directory is the database directory?
>>>>
>>>>
>>> If you mean 'where is the actual data stored' then it
>>> is /var/lib/mysql/'your-application-database-name'. If you want to know
>>> where the configuration files are stored it is /usr/share/mysql. However,
>>> the 'main' configuration file is /etc/mysql.cnf
>>>
>>> At least that's my 'observation'...
>> Why ain't there a GUI interface to operate the piece of crap? You have
>> to do all this secret back door crap to get this thing working.
>>
>
> So you know nothing and you call MySQL that?
> I don't know much but I'd call it anything else than that, you.
>
> You are something.
>
> Just in case you learn to behave in the _very_ near future:
>
> http://www.phpmyadmin.net/home_page/index.php
>
>
> And FYI that GUI is included in openSUSE.
>
> P.S. Try that behavior in MySQL or php groups...
>
> Vahis

Yes daddy.

--
Blattus Slafaly ف ٣ ⅞

On Mar 27, 5:23 pm, Michael Soibelman <in-...@ether.net> wrote:
<snip>
>
> P.S. If you want to 'see' where all your installed rpm's files are I
> recommend installing 'xrpm-2.2-3', which you can get here: (shift + left
> click to download !!)
>
> ftp://ftp.kddlabs.co.jp/pub/Linux/pa.../redhat-5.2/RP...
>
<snip>

Don't mean to hijack this thread - but you can also user KPackage. It
works quite well with the RPM database. You run it as normal user, and
only have to enter root password when installing/deleting rpm's.

Skippyboy wrote:

>
> On Mar 27, 5:23 pm, Michael Soibelman <in-...@ether.net> wrote:
> <snip>
>>
>> P.S. If you want to 'see' where all your installed rpm's files are I
>> recommend installing 'xrpm-2.2-3', which you can get here: (shift + left
>> click to download !!)
>>
>> ftp://ftp.kddlabs.co.jp/pub/Linux/pa.../redhat-5.2/RP...
>>
> <snip>
>
> Don't mean to hijack this thread - but you can also user KPackage. It
> works quite well with the RPM database. You run it as normal user, and
> only have to enter root password when installing/deleting rpm's.

Ahhh..I've been hijacked ! LOL

Yes kpackage does list packages. However, xrpm is a much quicker way to get
a straight alphabetical listing without a lot of clutter. Within 2 seconds
you can view all installed applications without the icons, groups, etc.
getting in the way. Just more succinct and to the point if you are looking
for something in a hurry. If I'm doing an install of a package from source
and there are unmet requirements I can search through my installed packages
quite quickly with xrpm. This saves much time. Sort of like the reason
many people use (x)emacs or vi(m) to do things efficiently. But both will
do and each has their own strengths/weaknesses. Kpackage does not have the
database irregularities that xrpm does while xrpm is much faster for a
quick alphabetic visual scan.

Get off of my airplane !! ;-)

birre wrote:
> On 2008-03-27 22:38, Blattus Slafaly 0/00 ? ? ? wrote:
>> Michael Soibelman wrote:
>>> Blattus Slafaly 0/00 ? ? ? wrote:
>>>
>>>> When you install Mysql with yast it creates lots of mysql directories.
>>>> Which directory is the database directory?
>>>>
>>>>
>>>
>>> If you mean 'where is the actual data stored' then it
>>> is /var/lib/mysql/'your-application-database-name'. If you want to know
>>> where the configuration files are stored it is /usr/share/mysql.
>>> However,
>>> the 'main' configuration file is /etc/mysql.cnf
>>>
>>> At least that's my 'observation'...
>>
>> Why ain't there a GUI interface to operate the piece of crap? You have
>> to do all this secret back door crap to get this thing working.
>>
>
> The secrets are to read instructions.
>
> Just do rcmysql start and it TELL YOU what to do.
> Set the password for root and root@yourhost.domain
>
> Create the file /root/.my.cnf , make it readable only for root.
> add:
>
> [client]
> user = root
> password = 'the password for root'
>
>
> Now you can do mysqlshow , mysqladmin, mysql , mysqldump without
> passwords and things as root.
>
> and install mysql-administrator from mysql.com if you need a GUI.
>
> /bb

Why do I get this with mysqlshow?
mysqlshow: Access denied for user 'username'@'localhost' (using
password: NO)
and as root:
mysqlshow: Access denied for user 'root'@'localhost' (using password: YES)
why can't I access my own system?

--
Blattus Slafaly ? 3 7/8