[���X�g�ւ��ǂ�]
�ꊇ�\��


<PR> ���z2100�~/3675�~�ŃO���[�o���Œ�IP���擾�A�T�[�o�\�z�EVPN�ESOHO���”\�B �uZOOT for B�t���b�c�v

�^�C�g���F Mysql
�L��No�F 207
���e���F 2005/04/28(Thu) 17:44
���e���F Linux���S��
�����b�ɂȂ��Ă���܂��BLinux���S�҂ł��B
���x��MySQL�̃G���[�ł��B
----------------------------------
$ su
# useradd mysql
# su mysql
$ tar -zxvf mysql-3.23.52.tar.gz
$ cd mysql-3.23.52/
$ ./configure
�@�@--prefix=/usr/local/mysql
�@�@--with-charset=ujis
�@�@--with-extra-charsets=all
�@�@--with-mysqld-user=mysql
�@�@--without-bench
�@�@--localstatedir=/home/mysql/data
$ make
$ su
# make install
----------------------------------------
�ȉ��̃R�}���h�ŃC���X�g�[�����܂���
�R���p�C���ȂǂɃG���[�͌����Ȃ������̂ł����A�A

.bash_profile��
-------------------------------------
PATH=$PATH:/usr/local/mysql/bin
export MANPATH=$MANPATH:/usr/local/mysql/man
-------------------------------------
���L�q��
$source .bash_profile
$/usr/local/mysql/bin/mysql_install_db --user=mysql
install_db�̃R�}���h��ł��Ă݂��
----------------------------------------------------------
���ԁF /usr/local/mysql/libexec/mysqld: Shutdown Complete

To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/mysql/bin/mysqladmin -u root password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h www.xxx.jp password 'new-password
'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

You can start the MySQL daemon with:
cd /usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the /usr/local/mysql/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
-----------------------------------------------------------
���̃R�}���h���݂����Ȃ��Ƃ������Ă���悤�Ȃ̂őł��Ă݂��
/usr/local/mysql/bin/mysqladmin -u root password 'xxxxx'
-----------------------------------------------------------
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
-----------------------------------------------------------
/tmp/mysql.sock�@�͑��݂��Ă���I�Ƃ����܂���
/tmp/mysql.sock��T���Ă݂�ƌ�������܂���B
�F�X�����ɂ����Č��Ă�̂ł����Amysqld���N���`�`������
�T�C�g�����܂茩�‚���܂���B
�ǂ����F�l�̂��͂����݂��������B

�^�C�g���F Re: MySQL�͋N�����Ă��܂����H
�L��No�F 208
���e���F 2005/04/28(Thu) 19:11
���e���F marron(�Ǘ��l)
�Q�Ɛ��F http://www.marronkun.net/
Linux���S�җl

marron�ł��B
> -----------------------------------------------------------
> ���̃R�}���h���݂����Ȃ��Ƃ������Ă���悤�Ȃ̂őł��Ă݂��
> /usr/local/mysql/bin/mysqladmin -u root password 'xxxxx'
> -----------------------------------------------------------
> /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
> '
> Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
> -----------------------------------------------------------
> /tmp/mysql.sock�@�͑��݂��Ă���I�Ƃ����܂���
> /tmp/mysql.sock��T���Ă݂�ƌ�������܂���B
> �F�X�����ɂ����Č��Ă�̂ł����Amysqld���N���`�`������
> �T�C�g�����܂茩�‚���܂���B
> �ǂ����F�l�̂��͂����݂��������B
��Ԃ����̃��b�Z�[�W�ł���myslq���ǂ��ۂ��Ă��邩�`�F�b�N���ĉ������Ƃ����G���[
�ł��̂ł܂��́Amysql���N�����Ă��������B

�N�����@�ł����蓮�ł�
# /usr/local/mysql/bin/safe_mysqld --user=mysql &
�Ǝ��s���܂��B
�蓮�V���b�g�_�E����
# /usr/local/mysql/bin/mysqladmin shutdown
�ɂȂ�܂��B

�����N���X�N���v�g�ł̋N���̏ꍇ��
http://www.marronkun.net/linux/other/mysql_1.html
�̋N�����@���Q�Ƃ��ĉ������B

mysql�����삵����A���삪�ł���悤�ɂȂ�܂��B

�ȏ�A��낵�����肢�v���܂��B

�^�C�g���F Re^2: MySQL�͋N�����Ă��܂����H
�L��No�F 209
���e���F 2005/04/28(Thu) 20:13
���e���F Linux���S��
���肪�Ƃ��������܂��B
Mysql���N�����ĂȂ������݂����Ȃ̂ł����A
�ǂ��ŊԈႦ���̂��@���‚��ƈႤ�R�}���h�H�ɂȂ��Ă܂����B

#/usr/local/mysql/bin/mysqld_safe &
�@�@�@�@�@�@�@�@�@�@�@^^^^^^^^^^^^^^
�ŋN��������ł���悤�ɂȂ�܂����B
�}�~�X�ł��B�B�@�ʃX���\����Ȃ��ł��B

> Linux���S�җl
>
> marron�ł��B
> > -----------------------------------------------------------
> > ���̃R�}���h���݂����Ȃ��Ƃ������Ă���悤�Ȃ̂őł��Ă݂��
> > /usr/local/mysql/bin/mysqladmin -u root password 'xxxxx'
> > -----------------------------------------------------------
> > /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
> > error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
> > '
> > Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
> > -----------------------------------------------------------
> > /tmp/mysql.sock�@�͑��݂��Ă���I�Ƃ����܂���
> > /tmp/mysql.sock��T���Ă݂�ƌ�������܂���B
> > �F�X�����ɂ����Č��Ă�̂ł����Amysqld���N���`�`������
> > �T�C�g�����܂茩�‚���܂���B
> > �ǂ����F�l�̂��͂����݂��������B
> ��Ԃ����̃��b�Z�[�W�ł���myslq���ǂ��ۂ��Ă��邩�`�F�b�N���ĉ������Ƃ����G���[
> �ł��̂ł܂��́Amysql���N�����Ă��������B
>
> �N�����@�ł����蓮�ł�
> # /usr/local/mysql/bin/safe_mysqld --user=mysql &
> �Ǝ��s���܂��B
> �蓮�V���b�g�_�E����
> # /usr/local/mysql/bin/mysqladmin shutdown
> �ɂȂ�܂��B
>
> �����N���X�N���v�g�ł̋N���̏ꍇ��
> http://www.marronkun.net/linux/other/mysql_1.html
> �̋N�����@���Q�Ƃ��ĉ������B
>
> mysql�����삵����A���삪�ł���悤�ɂȂ�܂��B
>
> �ȏ�A��낵�����肢�v���܂��B