Revision [1093]

Last edited on 2011-02-09 16:47:13 by FsseInfo
Additions:
==Secure==
Secure your mysql root account(s) by setting a root password, delete anonymous users and test databases
==Tune==
Chose an appropriate my.cnf from /usr/share/doc/mysql-server
# pwd
/usr/share/doc/mysql-server-5.0.77
# ls -l
total 52
-rw-r--r-- 1 root root 4972 Jan 29 2010 my-huge.cnf
-rw-r--r-- 1 root root 20970 Jan 29 2010 my-innodb-heavy-4G.cnf
-rw-r--r-- 1 root root 4948 Jan 29 2010 my-large.cnf
-rw-r--r-- 1 root root 4955 Jan 29 2010 my-medium.cnf
-rw-r--r-- 1 root root 2526 Jan 29 2010 my-small.cnf
Deletions:
==SECURE mysql root account(s)==
first change root password, delete anonymous users and test databases

Revision [917]

Edited on 2009-11-03 19:57:07 by FsseInfo
Additions:
first change root password, delete anonymous users and test databases
0)
# /usr/bin/mysql_secure_installation

Revision [634]

Edited on 2008-06-12 10:45:53 by FsseInfo
Additions:
$ /usr/bin/mysqladmin -h yoursvr.yourdom -u root -p password 'new-password'
Deletions:
$ /usr/bin/mysqladmin -h mysvr.mydom -u root -p password 'new-password'
Enter password: <youy created in step 1 !>

Revision [498]

Edited on 2008-05-02 17:57:14 by FsseInfo
Additions:
1)
2)
$ /usr/bin/mysqladmin -h mysvr.mydom -u root -p password 'new-password'
Enter password: <youy created in step 1 !>
Deletions:
$ /usr/bin/mysqladmin -u root -h mysvr.mydom password 'new-password'

Revision [477]

Edited on 2008-04-26 21:47:00 by FsseInfo
Deletions:
==BENCHMARK==
$ cd sql-bench
$ perl run-all-tests

Revision [476]

Edited on 2008-04-26 21:39:12 by FsseInfo
Additions:
==SECURE mysql root account(s)==
localhost
yoursvr.yourdom
$ /usr/bin/mysqladmin -u root -h mysvr.mydom password 'new-password'
----
REFERRERS
{{backlinks}}
Deletions:
==SECURE==
$ /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'

Revision [367]

Edited on 2007-04-12 12:07:58 by FsseInfo
Additions:
$ /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password'
Deletions:
$ /usr/bin/mysqladmin -u root-h localhost.localdomain password 'new-password'

Revision [366]

The oldest known version of this page was created on 2007-04-01 17:46:04 by FsseInfo
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki