Roman777
17-05-2007, 11:50
(im sorry for my english)
i have open suse 10.2. 64 bit + mysql 5.0.26 and i have this problem:
17-05-07 12:20:42,ALL,Info,server, Server init initialized
17-05-07 12:20:42,ALL,Info,server, Server version: 2.0.20.1 Linux
17-05-07 12:20:42,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
17-05-07 12:20:42,ERROR,All,SERVER, Start_Server: unable to open database
1) in phpmyadmin i add user "ts", add all privilegias, and add password - this user and pass i add to server.ini.
i find on this forum this:
SET PASSWORD FOR '<ts>'@'< localhost>' = oldPASS('<newPASS>');
phpmyadmin said:
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near oldPASS('<newPASS>')' at line 1
I try "decoment" in my.cnf "skip-networking", but my web on my webhosting (this web use data wit db on my pc)write me:
Error: Unable to connect to MySQL server. MySQL reported: Lost connection to MySQL server during query. Error: Unable to connect to MySQL server. MySQL reported: Lost connection to MySQL server during query.
a commented this....
my server.ini:
[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=ts
Hostname=localhost
User_name=ts
Password=pass
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient_r.so.10.0.0
LibraryName=/home/Nesseznam.cz/tss2_rc2/libsqlmy.so
Active=1
on phpmyadmin:
User PC pass Globální oprávnění Přidělování
ts % yes ALL PRIVILEGES Ano
Where is can be problem? Can You help me pls?
Thanks !!!!
i have open suse 10.2. 64 bit + mysql 5.0.26 and i have this problem:
17-05-07 12:20:42,ALL,Info,server, Server init initialized
17-05-07 12:20:42,ALL,Info,server, Server version: 2.0.20.1 Linux
17-05-07 12:20:42,ERROR,All,SQL, Database initialization error: EDatabaseError.dbExpress Error: Invalid Username/Password
17-05-07 12:20:42,ERROR,All,SERVER, Start_Server: unable to open database
1) in phpmyadmin i add user "ts", add all privilegias, and add password - this user and pass i add to server.ini.
i find on this forum this:
SET PASSWORD FOR '<ts>'@'< localhost>' = oldPASS('<newPASS>');
phpmyadmin said:
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near oldPASS('<newPASS>')' at line 1
I try "decoment" in my.cnf "skip-networking", but my web on my webhosting (this web use data wit db on my pc)write me:
Error: Unable to connect to MySQL server. MySQL reported: Lost connection to MySQL server during query. Error: Unable to connect to MySQL server. MySQL reported: Lost connection to MySQL server during query.
a commented this....
my server.ini:
[DBEXPRESS]
sqldir=mysql_sql
Drivername=mysql
Database=ts
Hostname=localhost
User_name=ts
Password=pass
GetDriverFunc=getSQLDriverMYSQL
VendorLib=./libmysqlclient_r.so.10.0.0
LibraryName=/home/Nesseznam.cz/tss2_rc2/libsqlmy.so
Active=1
on phpmyadmin:
User PC pass Globální oprávnění Přidělování
ts % yes ALL PRIVILEGES Ano
Where is can be problem? Can You help me pls?
Thanks !!!!