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. Quote 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. Quote 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. Quote 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. Quote 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!). Quote 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. Quote 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! Quote Link to comment https://forums.phpfreaks.com/topic/354-problems-starting-mysql/#findComment-1170 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.