Tech Support Forum - View Single Post - Problem with Open-Source Python with MySQL Program

**jamiemac2005** · 05-28-2009, 04:09 AM

Hey, it runs of of your localhost's mySQL server, so the easiest way is just through a mysql console...

I went and ran the situation on my own pc:
- Opened Evette, went to Staff->Edit Users->Changed pass, closed.
- Opened CMD, i have mysql in my path variable so you'd have to find the full path to mysql:

Code:

[path to mysql]/mysql.exe -u root

(this is if your mysql server's username is root and pass is blank (standard for this program))

- then in mysql the code goes something like:

Code:

mysql> use evette
Database changed
mysql> UPDATE user SET Password="newPass" WHERE ID=1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

The new password must be 10 characters/less.

But that's the easiest way to go about it i think.

Cheers,
Jamey

05-28-2009, 04:09 AM	#2 (permalink)
jamiemac2005 Design Team Member Join Date: Jul 2007 Location: Coventry, UK Posts: 1,883 OS: Vista, various linux distros	Re: Problem with Open-Source Python with MySQL Program Hey, it runs of of your localhost's mySQL server, so the easiest way is just through a mysql console... I went and ran the situation on my own pc: - Opened Evette, went to Staff->Edit Users->Changed pass, closed. - Opened CMD, i have mysql in my path variable so you'd have to find the full path to mysql: Code: [path to mysql]/mysql.exe -u root (this is if your mysql server's username is root and pass is blank (standard for this program)) - then in mysql the code goes something like: Code: mysql> use evette Database changed mysql> UPDATE user SET Password="newPass" WHERE ID=1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 The new password must be 10 characters/less. But that's the easiest way to go about it i think. Cheers, Jamey __________________ Myspace Last edited by jamiemac2005; 05-28-2009 at 04:12 AM.