Showing posts with label Nguyen Si Nhan. Show all posts
Showing posts with label Nguyen Si Nhan. Show all posts

Saturday, November 26, 2011

*Exception Details: *System.Data.SqlClient.SqlException: Login failed for user


*Exception Details: *System.Data.SqlClient.SqlException: Login failed for
user 'SIN2\Iusr_7503870'.



Resolution:


Open file web.config delete these character:


Integrated Security=SSPI


And then save your file ,Now It 'll run OK.Done.


Nguyen Si Nhan

Sunday, November 13, 2011

How to restore or backup database mysql by cmd (command)


Restore
mysql -u user_name -p your_password database_name < file_name.sql
 gzip -dc <database.sql.gz |mysql -u root -p databasename

Backup
mysqldump -u user_name -p your_password databasename > file_name.sql
mysqldump -u user_name -p databasename | gzip > database.sql.gz

Nguyen Si Nhan

How to: reset pass root mysql

1. Stop mysql:
# service mysqld stop
or
#killall mysql

2..mysqld_safe --skip-grant-tables
3.Access mysql without password
4.Create new mysql root password :
UPDATE mysql.user SET Password=PASSWORD('YOUR-NEW-MYSQL-PASSWORD') WHERE User='root';
FLUSH PRIVILEGES;
4.killall mysqld
5.service mysqld start


Nguyen Si Nhan