cl5814 Posted April 9, 2006 Share Posted April 9, 2006 i installed and worked with mysql 5.0.19 before i updated php and httpd using 'yum' on linux (fedora 4).now, i want php 5.0.4 to detect that i have mysql 5.0.19 installed. running yum to install mysql, downloads and installs mysql 4, which i don't want. i have both mysql 4 and mysql 5 now installed. haven't tested mysql 4. when i log in to mysql, i get 5.0.19.php reports that it is using /var/lib/mysql, which contains mysql 5.0.19; guess php thinks it is mysql 4.i can't connect from php to mysql. get error message that i can't connect.i tried to manually connect to mysql, but can't remember the password for mysql. i don't remember the password for mysql$mysql -h localhost -u mysql -pEnter password:ERROR 1045 (28000) Access denied for user 'mysql'@'localhost' (using password: YES)how do i reset the mysql password ? what am i gonna break fi i reset the password ?thnaks, lots of questions, i know. Link to comment https://forums.phpfreaks.com/topic/6936-php-and-mysql-connect/ Share on other sites More sharing options...
fenway Posted April 9, 2006 Share Posted April 9, 2006 You won't break anything -- it's just a password. You can search the refman for instructions on resetting the root password, or try and strart mysql with "--skip-grant-tables" and try and update the users table directly. Link to comment https://forums.phpfreaks.com/topic/6936-php-and-mysql-connect/#findComment-25299 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.