Friday, 20 April 2012
access my sql remotely
Solved: How to enable remote access to MySQL server on Windows XP
Hi there,
On Linux, we can easily enable remote access to MySQL server, but on Windows, I got no success so far ( a client tried to connect to MySQL on the server)
Here's the steps to do that (on the server computer):
1. Open a DOS command prompt on the server.
2. Run the following command from the mysql\bin directory:
mysql -u root --password=
3. A mysql> prompt should be displayed.
4. To create a remote user account with root privileges, run the following commands:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
'USERNAME' is the username to be created.
'IP' is the public IP address of the remote connection.
'PASSWORD' is the password to be assigned for this username.
(IP can be replaced with % to allow this user to logon from any host or IP)
mysql> FLUSH PRIVILEGES;
mysql> exit;
On Linux, we can easily enable remote access to MySQL server, but on Windows, I got no success so far ( a client tried to connect to MySQL on the server)
Here's the steps to do that (on the server computer):
1. Open a DOS command prompt on the server.
2. Run the following command from the mysql\bin directory:
mysql -u root --password=
3. A mysql> prompt should be displayed.
4. To create a remote user account with root privileges, run the following commands:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';
'USERNAME' is the username to be created.
'IP' is the public IP address of the remote connection.
'PASSWORD' is the password to be assigned for this username.
(IP can be replaced with % to allow this user to logon from any host or IP)
mysql> FLUSH PRIVILEGES;
mysql> exit;
Thursday, 19 April 2012
getback windows bootloader
Get the Windows 8 Developer Preview boot menu back.
- Start from the Windows 8 Developer Preview installation medium.
- Optionally, choose your keyboard settings.
- Hit SHIFT+F10 to enter the command prompt.
- Execute
bootrec /fixmbr
to update the main boot record just to be sure, partitions will remain. - Execute
bootrec /fixboot
to update the boot sector of the system partition. - Execute
bootrec /scanos
to add known OSes to the boot configuration data.
Get it to list Windows XP.
- Execute
bootrec /rebuildbcd
, this will rebuild the boot configuration data. - If that doesn't work, reboot and use
bcdedit
from Windows 8 Developer Preview like this:
Please note that you need to right click the Command Prompt tile, then click on advanced in the lower right corner and then click onbcdedit /create {ntldr} /d "Windows XP" bcdedit /set {ntldr} device partition=X: bcdedit /set {ntldr} path \ntldr bcdedit /displayorder {ntldr} /addlast
Run As Administrator
. ReplaceX:
by your XP partition.
Subscribe to:
Posts (Atom)