MySQL
, MySQL superuser . MySQL keying in . , , MySQL.
MySQL has ? -:
:
- MySQL .
- MySQL . a a , :
Menu > > >
MySQL in , .
your a , .
- a a :
‘root@'localhost’’ = PASSWORDMyNewPassword(’’);
. Cmysql:\-init.txt.
- a DOS :
Menu > > cmd
- MySQL in Cmysql:\. MySQL in , .
DOS , :
c:\> Cmysqlbinmysqld:\\\-nt – -fileCmysql=:\-init.txt
– - , . has , Cmysql:\-init.txt.
MySQL using MySQL , a – - :
c:\> “CProgram:\ FilesMySQLMySQL\\ 5.0binmysqld\\-nt.exe”
–-fileCProgram=”:\ FilesMySQLMySQL\\ 5.0my.ini\”
–-fileCmysql=:\-init.txt– - using :
Menu > > >
MySQL in , - , . – - . – - , your
- MySQL , in . MySQL p.t. run a , . , .
- MySQL using .
Unix , resetting :
- Unix Unix mysqld runs .
- .pid ’ ID. your , hostname, . var/lib/mysql/, var/ /mysqld/, usr/ /mysql/ /./// , filename has .pid mysqld ’ hostname.
MySQL a ( 9) mysqld , using pathname .pid in :
> `cat mysql- - /host_name.pid`
/backticks - ; .
- a a :
‘root@'localhost’’ = PASSWORDMyNewPassword(’’);
. ~/mysql- .
- MySQL – - =~/mysql- :
> mysqld_safe – - =~/mysql- &
- , . has ~/mysql- .
- MySQL using .
, , mysql client , its’ - resetting ( ):
- mysqld – - - –userroot= ( –userroot= ).
- mysqld :
> mysql u
- in mysql client:
mysql> UPDATE mysql.user PasswordPASSWORDnewpwd=(’’)
-> Userroot=’’;
mysql> ;‘newpwd’ .
- using .
: a ? " " . . English .
My .
- MySQL
- in 6.0 2.2, MySQL 5.0 PHP 5 3
- in XP , PHP5 MySQL4 4
- Optimize MySQL Database Automatically /
- Using phpMyAdmin MySQL in XP
- Munin MySQL
- WordPress P.p. forget
- AdSense Google
- Login SSH
- phpBB 2 in XP 2, PHP 5 MySQL 4
(RSS)
6th, 2006 1812:
[...] mySQL database in p.p. forget , in , : [...]
8th, 2007 0347:
– – in 5. p.t. p.p. get a a a ’ feedback – . , CTRL- C , linux.
-Mike
23rd, 2008 2338:
isnt’ . “– ” “- ”.
23rd, 2008 2339:
Ah Ive’ . disallowing “-”. Its’ .
, “- ” ( ), .
23rd, 2008 2339:
Gah. “” “ ”. Im’ .
24th, 2008 1005:
,
Didnt’ , - .
my documentation !! A ! -
25th, 2008 0137:
a typo mysqld .
parameter .
( - - ):
mysqld_safe – - -
31st, 2008 2118:
Procdure in MySQL [RedHat & Fedora]
======================================================
-1
[root@redhatkillall~]# mysqld
[root@redhat~]#/usr/ /mysqld – - - –userroot= &
======================================================
-2 (In MySQL)
[root@redhatmysql~]#
mysql;
update passwordpasswordnewpassowrd=(””) userroot=””;
;
;
======================================================
-3
[root@redhatkillall~]# mysqld
[root@redhat~]#/etc/ /mysqld
14th, 2008 1047:
phpmyadmin