Nylex Posted April 15, 2003 Share Posted April 15, 2003 I\'ve installed MySQL from source (version 4.0.12 and I\'m using Red Hat 8.0). Am I supposed to start MySQL using ./mysql user=mysql (or root)? I get command not found errors if I just try # mysql or # mysqld. When I do use ./mysql ..., it gives the following error message: ERROR 2002: Can\'t connect to local MySQL server through socket \'/tmp/mysql.sock\' (2) Can anyone help? Thanks. Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/ Share on other sites More sharing options...
effigy Posted April 15, 2003 Share Posted April 15, 2003 as root run ./mysqladmin ping and make sure it\'s running. Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1156 Share on other sites More sharing options...
Nylex Posted April 15, 2003 Author Share Posted April 15, 2003 It came up with the same error when I tried ./mysqladmin ping. I then did ./mysqld_safe --user=mysql and then ./mysqladmin again: ./mysqladmin: connect to server at \'localhost\' failed error: \'Access denied for user: \'root@localhost\' (Using password: NO)\' Thanks. Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1160 Share on other sites More sharing options...
effigy Posted April 15, 2003 Share Posted April 15, 2003 good deal. now it\'s running. just use the -p switch and it will prompt you for a password. you should have set the root password on installation. Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1162 Share on other sites More sharing options...
Nylex Posted April 15, 2003 Author Share Posted April 15, 2003 I did set the password when I installed. Lol. Thanks a lot (again!). Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1163 Share on other sites More sharing options...
effigy Posted April 15, 2003 Share Posted April 15, 2003 no problem. if you do not want to type -p everytime, open the mysql configuration file and under the heading for the binary, [mysql] for example, put a line under there that simply says \"password.\" now anytime you use mysql it will automatically prompt for a password. no switches needed. Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1165 Share on other sites More sharing options...
Nylex Posted April 16, 2003 Author Share Posted April 16, 2003 Cheers, I\'ll do that. Now my LAMP server is up and running! Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1170 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.