1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Riverside, CA 92507
    Rep Power
    Do I enter the following sequence -
    mysql> -uuserid -ppassword
    in the MySQL Monitor? If I am supposed to, then I'm having problems. I can't gain access to begin playing with the database. Also, I have a filemaker pro database. How do I go about importing this into MySQL? Do I set up tables first in MySQL? Help me, please! I'm a novice completely willing to learn. Also, keep in mind (if this has any bearing on your advice), I'm working on a Power mac.
  2. #2
  3. No Profile Picture
    Gödelian monster
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jul 1999
    Central Florida, USA
    Rep Power
    mysql -u username -h hostname -ppassword

    This gets you into the mysql> monitor with the access rights you need. Then you can perform your SQL commands.

    Now the explanation:

    -u username is separated by a space
    -h hostname is sometimes necessary depending on how your user access rights are setup. Usually it defaults to 'localhost', in which case you don't need to use it, but if another hostname is required by your MySQL user profile, you need to specify it.
    -ppassword is not separated by a space. You can just use -p, and you will be prompted for a password. The reason for the -ppassword thing is if you want to automate a MySQL action from a shell script or Perl. The reason there is not a space is because after sending the user access info, you can also specify a database, and call a text file that runs SQL commands on that database.

    For example:

    mysql -u username -h hostname -p databasename < textfile.sql

    would prompt you for a password, then run the contents of the textfile as a series of commands on 'databasename'

    mysql -u username -h hostname -ppassword databasename < textfile.sql

    would do the same, but without prompting for the password.

    It doesn't matter what kind of computer you are using to access your ISP, as long as you have a decent Telnet client.

    [This message has been edited by rycamor (edited September 12, 2000).]

Similar Threads

  1. MySQL Access through External Sources
    By andyjamison in forum MySQL Help
    Replies: 1
    Last Post: February 17th, 2004, 07:02 AM
  2. From Access to remote MySQL
    By TimMatthews in forum Database Management
    Replies: 0
    Last Post: February 3rd, 2004, 09:54 AM
  3. Replies: 0
    Last Post: January 30th, 2004, 08:46 PM
  4. database type: mySQL, MS SQL and Access
    By vinyl in forum ColdFusion Development
    Replies: 5
    Last Post: January 27th, 2004, 07:25 PM
  5. MySQL Access from SUN ONE
    By meyerc75 in forum MySQL Help
    Replies: 5
    Last Post: January 24th, 2004, 01:23 PM

IMN logo majestic logo threadwatch logo seochat tools logo