Re: Mysql
- From: birre <spamtrap@xxxxxxxxxxxx>
- Date: Fri, 28 Mar 2008 11:47:39 +0100
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
.
- Follow-Ups:
- Re: Mysql
- From: Blattus Slafaly 0/00 ? ? ?
- Re: Mysql
- References:
- Prev by Date: Re: crontab under user not working
- Next by Date: Re: Mount encrypted partition with exec
- Previous by thread: Re: Mysql
- Next by thread: Re: Mysql
- Index(es):
Relevant Pages
|
