Computer and Internet

Ports Yahoo! Messenger uses! Yahoo! Messenger services uses a variety of ports. These are list of ports Chat & Messenger TCP Port 5050: Client Access only Insider/Room Lists TCP Port 80: Client Access only File Transfer TCP Port 80: Server Access. Your ISP may block this port, as its used for web hosting. You can change port in Messenger, Preferences, File Transfer. Voice Chat UDP 5000-5010 TCP 5000-5001: Client Access If UDP Fails, TCP will be used instead, see below. WebCam TCP Port 5100: Client Access Super Webcam TCP Port 5100: Server Access P2P Instant Messages TCP Port 5101: Server Access PMs between Buddys may not use the Yahoo! Server, but this is not a requirement.

User management is an important aspect of managing a MySQL Server. This section covers the most common user management features encountered while managing a server. Creating a New User Account To create a new user account, first log in as root. Next, use the following command to create the user. GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY 'some_password'; flush privileges; This command would give the new user all privileges on all databases and tables. The user could only log in from the host specified by localhost. For the changes to take effect, you must call the flush privileges; command to make the server reread the user table. The previous command is not something you would generally do. A more reasonable command line might look like this. GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON db.* TO 'username'@'localhost' IDENTIFIED BY 'password'; flush privileges; This example explicitly identifies the privileges

This tip would be useful for those who are either making backup of their remote mysql database or moving their web hosting to their provider. Here’s how to export mysql DB to SQL file using command-line utility : mysqldump –user=username –password=1234 –databases your_database –opt –quote-names –complete-insert > example.sql or you can use this command : $ mysql -u username -p dbname > database.sql If the MySQL programs are not in your path, you will need to manually specify the location of the mysqldump program: $ /usr/local/mysql/bin/mysqldump -u username -p --opt dbname > database.sql Download the database.sql and keep it in a safe place (CDR, Zip disk, etc). If you need to restore your database, you can do so like this: $ mysql -u username -p databasename < database.sql