Invitation to connect on LinkedIn

From Asad Yousufi Manager Software Engineering at Foresight Technologies Pvt Ltd Pakistan I'd like to add you to my professional network on LinkedIn. - Asad Confirm that you know Asad You are receiving Invitation to Connect emails. Unsubscribe © 2012, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA

MYSQL Enable Users or Root Remote Access Suse Linux 11.3

All you need to do is update the user table host fields with % for which ever user you need to grant remote access permission.

Remember that when you remotely try to connect, if there is no connection, means Firewall or network issue, if there is an access dined error mean you need to follow the below demonstration:


TestManager:~ # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.46-log SUSE MySQL RPM

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Database changed
mysql> select host,user from user;
+------------+-----------------+
| host       | user                |
+------------+-----------------+
| %          | root                  |
| %          | super_user     |
| 127.0.0.1  | root             |
| linux-npc5 |                     |
| linux-npc5 | root             |
| localhost  |                      |
| localhost  | asad            |
| localhost  | my_new_username |
| localhost  | root              |
+------------+-----------------+
9 rows in set (0.00 sec)

mysql> update user set host='%' where user='root' and host='linux-npc5';
ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'
(This error came because I have two records for user root, one is correct one is bad, let delte the bad one)
mysql> delete  from user where user='root' and host='linux-npc5';
Query OK, 1 row affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql>
========================================================================

Testing from Workbench:

Final Exam Result

Final Exam Result is now updated, to view the result, open your attendance and progress sheet.

Project submission

All students are advised to submit their project by tomorrow at 5 pm.

Regards,
Asad Yousufi
Manager Software Engineering Foresight Technologies PVT. Ltd
Sent from my Nokia phone

Final Lab time update

In order so resolve final lab time conflict with communication skills presentation, final lab is scheduled to be stared at 5 PM, since students previously confirmed 24 as a free day for lab it was scheduled for full day activity.

Ragards,
Asad Yousufi
Sent from my Nokia phone

Final Lab

This post is published as a reminder of final Lab exam date and time:

Final Lab exam is scheduled on 24 of November, all students must appear at 3:30 pm at ground floor lab.

Short attendance notice!

Attendance percentage appeared Red for students having attendance below 75% in online attendance and marks sheet.

Link to attendance sheet:
https://docs.google.com/spreadsheet/ccc?key=0ArGVlyT5tewQdFFFc3J3NTFDODNFQ1hVTmNFNDZ0aEE&hl=en_US#gid=0

These students are not eligible for appearing in final lab and exam.

Such students must have to get an approval letter stamped and signed by chairman, and present it on attendance of lab and final exam.

Regards,
Asad Yousufi