Bash and mysql issue

papa2ae · 06-14-2011, 06:08 AM

I have tried many different ways to interact with the mysql to reset the root mysql pass.

This is what I got to right now ...

Code:

#!/bin/sh

newpass=$1

service mysqld stop

mysqld_safe --skip-grant-tables --skip-networking &

echo "use mysql;" >> /tmp/mysql_pass_reset.txt
echo "update user set password=PASSWORD(\"$newpass\") where User=\"root\";" >> /tmp/mysql_pass_reset.txt
echo "FLUSH PRIVILEGES;" >> /tmp/mysql_pass_reset.txt

mysql -h localhost -uroot < /tmp/mysql_pass_reset.txt


service mysqld stop


service mysqld start


rm -rf /tmp/mysql_pass_reset.txt

If i run the commands manually, it works - but automatically with bash it doesn't.

This however, tested and all, doesn't seem to work. It doesn't really update the pass with the new one. And any password will work and drop the user into mysql console aswell.

Am I missing something? :P

ty

ssrameez · 06-14-2011, 06:15 AM

i am not an expert in mysql.
But will the following help.

mysql --host=localhost --user=root --password=password < /tmp/mysql_pass_reset.txt

papa2ae · 06-14-2011, 06:17 AM

Well ...

because we start mysql as mysqld_safe and we skip networking and grant tables. You can login without password so you can reset the pass.

So

mysql -h localhost -uroot < /tmp/mysql_pass_reset.txt

Will work ...

but for some reason, in the bash code, it doesn't work - but it works manually.

ssrameez · 06-14-2011, 06:19 AM

Another troubleshooting thought..

`mysql -h localhost -uroot < /tmp/mysql_pass_reset.txt`
try this in the script.

ssrameez · 06-14-2011, 06:22 AM

also have look at "http://www.linuxquestions.org/questions/linux-server-73/sql-commands-inside-bash-script-879004/"

papa2ae · 06-14-2011, 06:28 AM

Quote:

`mysql -h localhost -uroot < /tmp/mysql_pass_reset.txt`

However, when i run the code now and debugged

I get when inserting /tmp/mysql_pass_reset.txt into the mysql

ERROR 2002 ; which is cant connect to local mysql server through socket ... /var/lib/mysql/mysql.sock

and apparently the mysqld_safe doesnt seem to work either :S

Any help is appreciated <3

ty

papa2ae · 06-14-2011, 04:39 PM

Any other ideas?

:/

ty