| Username : Date : Action : Comments [ close all ] |
|
|
|
calban_6502 : 04/11/03 06:40 AM : Incident created |
|
- I have installed mysql but am unable to access it. I have tried to start it and to set the root password as indicated in the manual. However, all I get are messages similar to;
[bob@Linux bin]$ cd /
[bob@Linux /]$ whereis mysql_install_db
mysql_install_db: /usr/bin/mysql_install_db
[bob@Linux /]$ cd /usr/bin/
[bob@Linux bin]$ mysql_install_db
Installing all prepared tables
031104 16:51:14 /usr/sbin/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 !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h Linux 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/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/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
[bob@Linux bin]$
Unfortunately, this, to me, is meaningless babble.
Any assistance would be gratefully appreciated.
|
|
|
|
Linegod_7611 : 04/11/03 06:45 AM : Reply received |
|
- Did you install MySQL from the Mandrake RPMS? They are on the CDs.
If you did, simply open up a console (ALT-F2 and type 'konsole') and switch to root (type 'su') and
do:
# /etc/rc.d/init.d/mysql restart
If you didn't install MySQL from the RPMs, I would recommend that you uninstall the version you
have and do:
# urpmi MySQL
-------------
Note: If this answer resolves your problem, please remember to close this incident.
|
|
|
|
calban_6502 : 05/11/03 06:06 AM : More info provided |
|
- Followed you advice and this is the result
[bob@Linux bob]$ su
Password:
[root@Linux bob]# /etc/rc.d/init.d/mysql restart
Stopping MySQL Server
[FAILED]
Starting MySQL Server [ OK ]
[root@Linux bob]#
[root@Linux bob]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@Linux bob]#
|
|
|
|
Linegod_7611 : 06/11/03 12:19 AM : Reply received |
|
- Open up one console and do:
# su
# tail -f /var/log/messages
Then open a second console and do:
# su
# killall mysql
# /etc/rc.d/init.d/mysql restart
# /etc/rc.d/init.d/mysql restart
Check the '/var/log/messages' for anything relating to mysql and post it.
-------------
Note: If this answer resolves your problem, please remember to close this incident.
|
|
|
|
calban_6502 : 06/11/03 06:12 AM : More info provided |
|
- As suggested, here are the results
[bob@Linux bob]$ su
Password:
[root@Linux bob]# tail -f /var/log/messages
Nov 6 16:26:05 Linux pppd[2249]: remote IP address 203.220.79.5
Nov 6 16:26:05 Linux pppd[2249]: primary DNS address 203.194.56.150
Nov 6 16:26:05 Linux pppd[2249]: secondary DNS address 203.194.27.57
Nov 6 16:27:37 Linux nmbd[1837]: [2003/11/06 16:27:37, 0] nmbd/nmbd_become_lmb. c:become_local_master_stage2(404)
Nov 6 16:27:37 Linux nmbd[1837]: *****
Nov 6 16:27:37 Linux nmbd[1837]:
Nov 6 16:27:37 Linux nmbd[1837]: Samba name server LINUX is now a local maste r browser for workgroup MDKGROUP on subnet 192.168.16.150
Nov 6 16:27:37 Linux nmbd[1837]:
Nov 6 16:27:37 Linux nmbd[1837]: *****
Nov 6 16:35:33 Linux su(pam_unix)[2358]: session opened for user root by (uid=5 01)
Nov 6 16:36:27 Linux su(pam_unix)[2430]: session opened for user root by (uid=501)
Nov 6 16:37:05 Linux mysql: No mysqld pid file found. Looked for /var/lib/mysql/Linux.pid. fa iled
Nov 6 16:37:05 Linux mysql: succeeded
Nov 6 16:37:05 Linux mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov 6 16:37:05 Linux mysqld_safe: 031106 16:37:05 mysqld ended
Nov 6 16:37:05 Linux mysqld_safe:
Nov 6 16:37:25 Linux mysql: No mysqld pid file found. Looked for /var/lib/mysql/Linux.pid. fa iled
Nov 6 16:37:25 Linux mysql: succeeded
Nov 6 16:37:25 Linux mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql
Nov 6 16:37:25 Linux mysqld_safe: 031106 16:37:25 mysqld ended
Nov 6 16:37:25 Linux mysqld_safe:
and from the other terminal
[bob@Linux bob]$ su
Password:
[root@Linux bob]# killall mysql
mysql: no process killed
[root@Linux bob]# /etc/rc.d/init.d/mysql restart
Stopping MySQL Server
[FAILED]
Starting MySQL Server [ OK ]
[root@Linux bob]# /etc/rc.d/init.d/mysql restart
Stopping MySQL Server
[FAILED]
Starting MySQL Server [ OK ]
[root@Linux bob]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@Linux bob]# mysql -h Linux -u bob -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'Linux' (111)
[root@Linux bob]#
|
|
|
|
Linegod_7611 : 06/11/03 05:56 PM : Reply received |
|
- Nov 6 16:37:05 Linux mysqld_safe: Starting mysqld daemon with databases from
/var/lib/mysql
Nov 6 16:37:05 Linux mysqld_safe: 031106 16:37:05 mysqld ended
MySQL is dying immediately after start.
Try:
# /usr/bin/mysqld_safe
See if it outputs any errors.
-------------
Note: If this answer resolves your problem, please remember to close this
incident.
|
|
|
|
calban_6502 : 07/11/03 10:29 PM : More info provided |
|
- As suggested - here are the results
[bob@Linux bob]$ su
Password:
[root@Linux bob]# /usr/bin/mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
031108 08:56:21 mysqld ended
[root@Linux bob]# mysql -h Linux -u bob -p
Enter password:
ERROR 2003: Can't connect to MySQL server on 'Linux' (111)
[root@Linux bob]#
|
|
|
|
Linegod_7611 : 08/11/03 01:56 AM : Reply received |
|
- Try it without the '-h Linux'. It will default to localhost.
-------------
Note: If this answer resolves your problem, please remember to close this
incident.
|
|
|
|
calban_6502 : 26/12/03 04:05 AM : Incident closed |
|
- If it is not possible to access a piece of software then that software is less than useless. Although several people attempted to assist me in getting it going all failed. In addition, I left messages on the Mysql site. This group didn't even bother to reply.
As an MCSE (windows) person attempting to come to terms with Linux this does not bode well. I have, on numerous occasions installed Microsoft SQL with no problems, set up groups and users for SQL access, both using only SQL access and using the Windows users login with no problems whatsoever.
If this is the standard used by the linux/unix fraternity so show off their software it is no wonder that Microsoft has a monopoly in the market place.
Regards,
Bob
|
|
|
