Re: password? getting started
Ok, I logged on to the GUI Administrator as: root localhost /var/lib/mysql/mysql.sock from my linux user account. Tad confusing, as to which "root" is being referred to. If I, for instance, restart they system I'll need to manually restart the database? Or, if for some other reason the database is "stopped" it must be restarted? Hmm. And there are different levels of users for the database, apparently. Bit of adjustment required! -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: password? getting started
Got it started: [EMAIL PROTECTED] ~]# service mysqld start Initializing MySQL database: Installing all prepared tables Fill help tables ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 060201 3:46:14 [ERROR] Aborting 060201 3:46:14 [Note] /usr/libexec/mysqld: Shutdown complete WARNING: HELP FILES ARE NOT COMPLETELY INSTALLED! The "HELP" command might not work properly 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/bin/mysqladmin -u root password 'new-password' /usr/bin/mysqladmin -u root -h localhost.localdomain password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd /usr ; /usr/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/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 [ OK ] Starting MySQL:[ OK ] [EMAIL PROTECTED] ~]# date Wed Feb 1 03:46:44 EST 2006 [EMAIL PROTECTED] ~]# nano sql.2.txt [EMAIL PROTECTED] ~]# /usr/bin/mysqladmin -u root password 'password' [EMAIL PROTECTED] ~]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.1.16 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> quit Bye [EMAIL PROTECTED] ~]# date Wed Feb 1 03:48:43 EST 2006 [EMAIL PROTECTED] ~]# heh. Now I just have to figure out how to do stuff! :) -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
password? getting started
from linux Fedora, FC4: [EMAIL PROTECTED] ~]# yum -y groupinstall 'MySQL Database' Setting up Group Process Setting up repositories base 100% |=| 1.1 kB00:00 Setting up repositories Reading repository metadata in from local files Passing package list to Install Process Parsing package install arguments Nothing to do [EMAIL PROTECTED] ~]# mysql -h localhost -u root -p Enter password: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [EMAIL PROTECTED] ~]# whoami root [EMAIL PROTECTED] ~]# date Wed Feb 1 03:31:09 EST 2006 [EMAIL PROTECTED] ~]# Now, I've read reference indicating that first the password must be set. This isn't the password for the root account, nor for a user account on the local system, but a password for the database, yes? RTFM, I know, I'm going to the library first chance I can. -Thufir -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]