How To Use Vanilla Forum On MySQL Database Without Password Set �o�j���̃t�H�[�������g�p�����@��MySQL�f�[�^�x�[�X�Ƀp�X���[�h��ݒ肷��
First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea.�܂����ɂ��������Ƃm�ɂ��邱�Ƃ�MySQL�̃f�[�^�x�[�X�Ƀp�X���[�h��ݒ肹���A �i���Ȃ���root�A�J�E���g�j�́A���ɔ��Ɉ����l���ł��B However I wanted to set it up on my home machine which has XAMPP installed.������������������ݒ肷�邱�Ƃ����̃z�[���}�V���ł́A XAMPP���C���X�g�[�����܂��B And XAMPP by default creates a root account for MySQL without any password.��XAMPP�f�t�H���g�ł�MySQL root�A�J�E���g���쐬���邱�ƂȂ��p�X���[�h���͂��܂��B I had several applications installed in that configuration.���͂������̃A�v���P�[�V�����ɃC���X�g�[������A���̍\�����܂��B So I tried to do the same with Vanilla.������s���ɂ͓���������o�j�����悤�Ƃ��܂��B However Vanilla wouldn't allow me to do so.�������o�j���͂Ȃ���������s���ɂ͋����܂��B Actually the setup goes fine but then it refuses to show claiming failure to connect to the database.�������A���ۂ̃Z�b�g�A�b�v�������Ǝ咣���ďڍׂ����ۂ��āA�f�[�^�x�[�X�ւ̐ڑ��Ɏ��s���܂��B Here is a simple solution.�����ł́A�V���v���ȃ\�����[�V�����ł��B
Open conf\database.php .�I�[�v��������\ database.php�ł��B Add the line after $Configuration['DATABASE_USER'] = 'root'; - $�\��������̍s��lj�[ ' database_user ' ] = '���[�g' ; -
$Configuration['DATABASE_PASSWORD'] = "; $�\��[ ' database_password ' ] = " ;
That's all folks!����͂��ׂĂ̐l�X �I
BTW: Just so are on the same page; never ever do it (setup a MySQL root account without password) on any server exposed to the internet.�Ƃ���ŁF����́A����y�[�W�ゾ��;������x�Ƃ�邱�Ɓi MySQL��root�A�J�E���g�Ƀp�X���[�h��ݒ肷��j �A�C���^�[�l�b�g��̔C�ӂ̃T�[�o�[�ɂ��炳��Ă��܂��B I know I am repeating myself but it it very important as you surely understand.�������A���͒m���J��Ԃ��Ȃ������ɏd�v�Ȃ��Ƃ�{���ɗ������邱�Ƃł��B
Filed under��o����� Computer Security�R���s���[�^�Z�L�����e�B , �A Database�f�[�^�x�[�X , �A How To�ǂ̂悤�� , �A Open Source Software�I�[�v���\�[�X�̃\�t�g�E�F�A , �A PHP PHP�� , �A RDBMS RDBMS�̂�葽���� , �A Tech Note�Z�p�̃m�[�g , �A Web�E�F�u , �A Web Hosting�E�F�u�z�X�e�B���O , �A Web Services Web�T�[�r�X | |
| |
RSS 2.0 RSS 2.0�� | |
Trackback�g���b�N�o�b�N this Article |���̋L��|
Email this Article�d�q���[�����̋L��
You may also like to read��ǂނ悤�ɂ��邱�Ƃ��\ |



































