On Tue, Dec 25, 2001 at 02:16:27PM +0800, Arman wrote: >On Tuesday 25 December 2001 13:42, budsz wrote: >> >> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! >> This is done with: >> /usr/bin/mysqladmin -u root password 'new-password' >> See the manual for more instructions. > >mestinya sih udah jalan btw mysql daemonnya udah jalan blom? >punya saya bisa diaktifkan dengan safe_mysqld &
Yups, daemon mysql dah jalan via "/etc/init.d/mysql start" atau via "safe_mysqld &" kalo daemonya belom idup khan akan error gini: ---cut #whoami root #mysql ERROR 2002 : Can't connect to local MySQL server through socket '/var/run/mysqld /mysqld.sock' (111) ---cut Saya coba dng "mysqladmin create database-baru" (untuk flag mysqladmin) semuanya errornya model gini: ---cut #whoami root #mysqladmin variable mysqladmin: connect to server at 'localhost' failed error: 'Access deny for user: 'root@localhost' (using password: NO) ---cut nah kalo saya lakukan dengan user budsz misalnya: (untuk flag mysqladmin semuanya bisa). ---cut $whoami budsz $mysqladmin variable +----------------------------+-----------------------------+ | Variable_name | Value | +----------------------------+-----------------------------+ | back_log | 5 | | connect_timeout | 5 | | basedir | /usr/ | | datadir | /var/lib/mysql/ | | delayed_insert_limit | 100 | | delayed_insert_timeout | 300 | | delayed_queue_size | 1000 | | join_buffer | 131072 | | flush_time | 0 | | key_buffer | 8388600 | | language | /usr/share/mysql/english/ | | log | OFF | | log_update | OFF | | long_query_time | 10 | | low_priority_updates | OFF | | max_allowed_packet | 1048576 | | max_connections | 100 | | max_connect_errors | 10 | | max_delayed_insert_threads | 20 | | max_join_size | 4294967295 | | max_sort_length | 1024 | | max_write_lock_count | 4294967295 | | net_buffer_length | 16384 | | pid_file | /var/run/mysqld/mysqld.pid | | port | 3306 | | protocol_version | 10 | | record_buffer | 131072 | | skip_locking | ON | | skip_networking | OFF | | socket | /var/run/mysqld/mysqld.sock | | sort_buffer | 2097144 | | table_cache | 64 | | thread_stack | 65536 | | tmp_table_size | 1048576 | | tmpdir | /tmp/ | | version | 3.22.32 | | wait_timeout | 28800 | +----------------------------+-----------------------------+ ---cut Kalo sbg user budsz pake command "mysqladmin create database-baru" ---cut mysqladmin: create of 'database-baru' failed error: 'Access deny for user: '@localhost' to database 'database-baru'' ---cut Nah bagaimana agar user budsz itu bisa melakukan perintah "mysqladmin create database-baru" seperti layaknya root?, nah untuk error2 diatas kira2 solusinya gimana ya...? masalahnya untuk command "mysql_setpermission" pun nggak dibolehin untuk "create database", OK kalo seandainya user budsz nggak bisa create database, yg paling nggak khan user root yg bisa nah malah error seperti diatas, diharapkan user budsz bisa access database tsb dng privileges tertentu. yg penting gimana caranya user root bisa create database dulu deh. Thanks -- budsz -- Utk berhenti langganan, kirim email ke [EMAIL PROTECTED] Dapatkan FAQ milis dg mengirim email kosong ke [EMAIL PROTECTED] Informasi arsip di http://www.linux.or.id/milis.php3
