Re: Mysql

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@xxxxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: Mysql
    ... Which directory is the database directory? ... where the configuration files are stored it is /usr/share/mysql. ... You have to do all this secret back door crap to get this thing working. ... Create the file /root/.my.cnf, make it readable only for root. ...
    (alt.os.linux.suse)
  • Re: Run script as root from WebServer
    ... Note, that configuration files that are modifyable by root only, often are for a reason, so this does not improve the security of the service being configured, but it takes a forkand sudo out of the mix. ... server is written using the standard python SimpleXMLRPCServer, ... do not have serious authentication. ...
    (freebsd-questions)
  • Re: SUDOERS: how to setup in a school
    ... > to login using ROOT user or a user created with ROOT privileges, ... root using sudo. ... With regards to editing configuration files. ... Consider the following script: ...
    (comp.os.linux.security)
  • Re: Run script as root from WebServer
    ... and some other tasks that require root privileges. ... If the configuration files allow 'includes', then include a file that is ... Another option that we use is to have an XML-RPC server running ... rights as much as they respect the rights of the caribous. ...
    (freebsd-questions)
  • Re: Software for distribution of configuration files and changes
    ... distribut configuration files from one master to different ... systems - maintain configuration files on one machine for all ... To make rdist as root easier. ...
    (freebsd-stable)