๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

MySQL

MYSQL ์†Œ์Šค ์„ค์น˜๋ฒ• 2011. 5. 14. ♥Sunny♥/temp]# wget ftp://ftp.sulinux.net/mysql/mysql-5.0.33.tar.gz ♥Sunny♥/temp]# tar xvfzp mysql-5.0.33.tar.gz ♥Sunny♥/temp]# cd mysql-5.0.33 ♥Sunny♥/temp/mysql-5.0.33]# mkdir -p /home/mysql/data ♥Sunny♥/temp/mysql-5.0.33]# useradd -M -r -d /home/mysql/data -s /bin/bash -c "MySQL Server" -u 27 mysql ♥Sunny♥/temp/mysql-5.0.33]# rm -fr /home/mysql/data ♥Sunny♥/temp/mysql-5.0.33]# ./configure --p..
MYSQL ์ปดํŒŒ์ผ ์„ค์น˜์˜ต์…˜ 2011. 5. 14. โ˜†โ˜†โ˜†โ˜†โ˜†โ˜†โ˜†โ˜†โ˜† ๋ฒ„์ „๋ณ„ ์ปดํŒŒ์ผ ์„ค์น˜ ๋‚ด์šฉ โ˜†โ˜†โ˜†โ˜†โ˜†โ˜†โ˜†โ˜†โ˜† โ—โ—‘โ—โ—‘โ—โ—‘ MySQL_3 ๋ฒ„์ „ โ—โ—‘โ—โ—‘โ—โ—‘ ./configure --prefix=/usr/local/mysql \ --localstatedir=/usr/local/mysql/data \ --with-mysqld-user="mysql" \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-charset=euc_kr โ—โ—‘โ—โ—‘โ—โ—‘ MySQL_4 ๋ฒ„์ „ โ—โ—‘โ—โ—‘โ—โ—‘ ./configure --prefix=/usr/local/dbsql \ --localstatedir=/usr/local/dbsql/data \ --with-mysqld-user="dbadmin" \ --with-unix-socket-p..
MySQL ํ™˜๊ฒฝ ์„ค์ • ๋ฐ ๊ณ„์ • ๊ถŒํ•œ ์„ค์ • 2011. 5. 11. ♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥ ♥♥♥♥♥♥ ♥♥♥♥ ♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥♥ mysqladmin -u root password ************* ==> root์˜ ํŒจ์Šค์›Œ๋“œ ๋ณ€๊ฒฝ mysqladmin -u root -p reload ==> ์„ค์ • ๋‚ด์šฉ ๋‹ค์‹œ ๋กœ๋“œ mysqladmin -u rabbit -p create webrabbit ==> ๊ณ„์ • ๋ช…์˜๋กœ ๋””๋น„ ์ถ”๊ฐ€ mysqladmin -u rabbit -p reload ==> ์†Œ์†๋œ ๊ณ„์ •๊ถŒํ•œ๋งŒ ๋‹ค์‹œ ๋กœ๋“œ ์‹œ์ž‘ mysql -u sunny -p webrabbit ==> ์ผ๋ฐ˜ ์‚ฌ์šฉ์ž๋กœ ..

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”