We accept safe and secure Credit Card and PayPal Payments.
Perl Scripts

All Count
Attachment Mailer
Perl Scripts Build A FAQ Plus
Perl Scripts Clock In Center
eBackup Automated
Easy Poll
Fetch a File
Form Maker
Mailing List Server
MySQL Mate
PDF Creation
Quick Fix
Quote of the day
Speed Search
Task Manager
Traffic Pack
Upload Plus
Upload Gold
Upload Pro
Website Manager

Free Perl Downloads

Free Perl Scripts Main Page
Free Perl Scripts 404 Alerter
AccessLog Viewer
Build A FAQ
PHP Scripts eBackup
Free PHP Scripts ErrorLog Viewer
eVars - Server Info
HT Pass Creator
Upload Lite
Website Manager


Free Java Scripts Alert Boxes
Free JavaScripts Browser Sniffer
Check email
Slide Show
Window Maker

Extra Utilities

ASP Scripts Ascii Codes
Free ASP Scripts Color Picker
Font Finder
HT Pass Creator
Meta Cloak
Meta Magic
Pano Zooms
Server Size

Online Tutorials

Free HTML Scripts Glossary
Free HTML Scripts HTML
Build Traffic


About Us
Latest versions

Hawk Eye in Tennis

Should Hawk Eye replace linesmen and lineswomen at all tennis tournaments?

View all Polls

Run Polls on your site

Run your own Surveys

Store Download FAQs Contact Us Support Programming Policies  
Database connections     List of Categories

  1. How do I log in to MySQL?

  2. How do I connect to a MySQL database on a remote server?

  1. How do I log in to MySQL?

    You need the root or mysql username and password to log in to MySQL using Telnet or an SSH client. This then allows you to perform queries at the command prompt. At the command prompt, type
    mysql -u username -p
    Enter password when prompted. Once logged in, you can list all available databases by typing :
    Create a Database by typing :
    CREATE DATABASE databasename;
    and add users to a database by typing
    GRANT ALL PRIVILEGES ON databasename.* TO newuser@"%" IDENTIFIED BY "newpassword";
    The above statement would grant all available privileges to the new user who could connect to the server from any domain. When entering statements at the command prompt, you must terminate them with a semi-colon ;

    Top of Page

  2. How do I connect to a MySQL database on a remote server?

    You can set up database to allow connections from only the server it resides on (localhost), from a specific domain (remotedomain.com) or from any domain (%).
    GRANT ALL PRIVILEGES ON databasename.* TO
    user@localhost IDENTIFIED BY "password"
    GRANT ALL PRIVILEGES ON databasename.* TO 
    user@remotedomain.com IDENTIFIED BY "password"
    GRANT ALL PRIVILEGES ON databasename.* TO 
    user@"%" IDENTIFIED BY "password"

    Top of Page

Was this page helpful?    
Speed Search our site
Linux Hosting Plans from $9.12 per month, includes Plesk Control Panel, MySQL databases, cgi-bin, crontab manager and 50 email accounts.

Plesk Hosting
Linux servers with Plesk Control Panel, cgi-bin, crontab manager, Mysql, PHP and ASP.

Discounted Scripts
Subscribe to our periodial newsletter to receive special offers.

Bathroom Hygiene
How often do you thoroughly clean your bathroom?

View all Polls

Run Polls just like this one on your website!

About us | Contact us | Script FAQs | Script Support | Website Hosting | Our Policies | Store | Testimonials
Subscribers log in here. Subscribe to our periodical newsletter for special offers on commercial scripts, hosting, exciting business opportunities, and industry news and events. Our Mailing List Software is powered by Consolidator    
HTML Plain text
©1999 - 2015 All content Copyright PerlScriptsJavaScripts.com Proudly hosted by LinuxHostingPlans.com