George Hill
I bought a serial/USB lead from eBay - the NewLink model, which is cheaper than the one which George mentions. Delivery and installation were fine.
Incidentally, on my PC, it connects as COM3. You can find out the COM port number via Control Panel > System > Hardware > Device Manager > Ports (COM and LPT).
Unfortunally, it didn't work! I found out that I needed a null modem cable (around £3) as well.
So, my complete connector now looks like this:

PC >> USB lead >> gender changer >> null modem cable >> NC200

Mike Parr
OS X's command line and I have never been what I'd call 'friendly'; rather, we have a mutual respect and understanding about not messing with each other. (Well, as much of a mutual respect as one can have between a human being and a code window.)
While the average person should never have any reason to visit Terminal, Apple's command line interface app actually does give you access to quite a few neat tricks and shortcuts.. if you're willing to take a peek.

What is Terminal?

Apple's Terminal app is a direct interface to OS X's bash shell — part of its UNIX underpinnings. When you open it, Terminal presents you with a white text screen, logged in with your OS X user account by default.
Here's the important part: With a system administrator account and password, you have direct access to tweaking almost everything about your computer's software code; that means that while this little window provides great power, it comes with great responsibility. In short, be careful before using Terminal to execute commands, and make sure you understand what you're typing.
You can also use Terminal to securely connect to other machines, web servers, and even create your own scripts, but those are how-tos for another day. For now, we're going to focus on using Terminal to explore your own computer.

Basic Terminal commands you should know

Before we get started with the fun stuff, let's learn some basic Terminal terminology and commands. These form the framework for more complex interactions (aka, the fun stuff).

How to execute a Terminal command

Welcome
You can type something in the Terminal window until you're blue in the face, but it won't execute until you press the Return key on your keyboard. At that point, it will either return an error if you've typed something incorrectly, or the command will execute.
Unless you're executing a command that requires the display of text in Terminal, you won't have any indicator that what you've done has been successful; you'll just get a new line with your user name on it once the command is finished processing.
When writing commands and paths in Terminal, almost everything is case sensitive: This means that you need to remember to properly capitalize 'Dock' when referring to the Dock, or OS X won't understand your command.

What's a path?

You can use Terminal to get direct access to your files without using the Finder. To do so, you build something called a path. Paths look similar in some ways to website sub-directories, and follow the structure of your folders.
Paths take two forms: absolute paths and relative paths. An absolute path starts at the root level of your hard drive, and is displayed as '/'. So if you wanted to make a path to your Applications folder, you would write '/Applications/'.
Relative paths are defined based on where you've already navigated to, and represented by './'. For instance, if you go to the '/Applications/' folder in Terminal, that's your current working directory (cwd). You can then get to your Utilities folder by typing './Utilities/' rather than '/Applications/Utilities'.
When you first launch Terminal, you're starting in the current working directory of /Users/myusername/ (also known as your User folder).

How to display and move between files in Terminal

To actually put all this path knowledge to use, you'll need the Terminal commands for displaying and changing files.
ls: The 'ls' command, by itself, displays the contents of the cwd. So if I were just to type 'ls' in Terminal, it would display the contents of my user directory:
You can optionally add an absolute or relative or path if you want to view a different directories. So, for example, if I wanted to view the Utilities folder inside Applications, I could type 'ls /Applications/Utilities/'. This won't change your current working directory, but it'll let you view other directories on your hard drive.
You can add options to view more information about that directory. The options for 'ls' include:
cd: Where the 'ls' command lets you view a directory, the 'cd' command will actually move to that directory (change your cwd). For instance, if after viewing the Utilities folder, you want to move to it, you'd type 'cd /Applications/Utilities/'.
pwd: Write this command by itself to help you remember the path of your current directory. When typed into terminal, it will print the full path of your cwd.
man: This command, followed by another Unix command, lets you read the Unix manual about the second command. This is super useful if you want to try a cool Terminal trick you found online, but aren't sure what those commands actually do.
For instance, typing 'man ls' will get you information on the 'ls' command, which lists directory contents.

How to modify files, folders, and preferences in Terminal

defaults: This command is often used in Terminal tips and tricks to tweak applications and system settings via their preference files. You can use it to do things like disable transparency in the menu bar, always show your scroll bars, change trackpad behavior, and much much more. You'll usually see this paired with either 'write' and a string, as with this:
The code above lets you save all your screenshots as JPGs instead of the system default PNG.
killall: If you execute a Terminal command that affects any system process or app, you're going to need to reboot the process to make it take effect. 'killall' followed by the process will do so. (This is also another way to force quit misbehaving apps or processes if your Force Quit menu isn't behaving.) Remember, this command and its target are case sensitive.
ln: OS X has long offered aliases, which let you create links to files, folders, and applications elsewhere in the system without having to duplicate them. Unfortunately, certain apps don't play well with aliases. With the link command 'ln -s', you can create a low-level, UNIX-based symbolic link which most system processes will recognize. Likely, you'll never have to make a symbolic link, but on the off-chance you want to perform a Terminal trick that requires them, this is how you do it.
The first path listed is your original file's path; the second path is where you'd like your symbolic link.
chflags: This commands lets you view and change the flags on a file or folder. For most people, the only flags you're going to care about are 'hidden' and 'nohidden', which hide and unhide documents, respectively.
sudo: If you spend any time online, you've probably heard of 'sudo' before. This is Unix's override command, and lets you execute any command as an administrator — provided, of course, that you have the requisite password and permissions. It probably goes without saying, but as a Terminal beginner, it's generally a good idea not to mess with commands like 'sudo' unless you are 100 percent sure what you're doing.

How to use Terminal for fun and whimsy

say: Feeling lonely? You can make your computer say anything you like with the 'say' command, and you can even record it in audio format to your desktop, if you so choose.
telnet towel.blinkenlights.nl: This isn't technically something local to your Mac, but it's my all-time favorite Terminal trick. Some kind soul on the internet made an all-ASCII version of Star Wars: A New Hope; run the following code, and you'll be treated to a full showing. If it doesn't make you smile just a little bit, you might be dead inside.

macOS

Main

I am using debian linux.I have a linux machine on which mysql is install.I can log in to my linux machine using root user as well as other user.I can connect to mysql database on linux machine from windows machine using sqlyog.Now I want to execute queries on linux machine only using linux terminal
I tried some following things on terminal
I went to root directory then I went to /var/lib directory
I run following commands on terminal
everytime I have get following error message
ERROR 1045 (28000) Access denied for user 'root'@'localhost' (Using password NO)
please guide me for following
  1. How do I get mysql prompt in linux terminal?
  2. How I stop the mysql server from linux terminal?
  3. How I start the mysql server from linux terminal?
  4. How do I get mysql prompt in linux terminal?
  5. How do I login to mysql server from linux terminal?
  6. How do I solve following error?
ERROR 1045 (28000) Access denied for user 'root'@'localhost' (Using password NO)
Please give me solutions for above question.Thank You
Param-Ganak
Param-GanakParam-Ganak
2,48915 gold badges43 silver badges59 bronze badges

11 Answers

1.- How do I get mysql prompt in linux terminal?
At the Enter password: prompt, well, enter root's password :)
You can find further reference by typing mysql --help or at the online manual.
2. How I stop the mysql server from linux terminal?
It depends. Red Hat based distros have the service command:
Other distros require to call the init script directly:
3. How I start the mysql server from linux terminal?
Same as #2, but with start.
4. How do I get mysql prompt in linux terminal?
Same as #1.
5. How do I login to mysql server from linux terminal?
Same as #1.
6. How do I solve following error?
Same as #1.
Álvaro GonzálezÁlvaro González
109k31 gold badges198 silver badges288 bronze badges
To your first question:
or
depending on what you want to do. The password will be asked of you once you hit enter! I'm guessing you really want to use mysql and not mysqladmin.
For restarting or stopping the MySQL-server on linux, it depends on your installation, but in the common debian derivatives this will work for starting, stopping and restarting the service:
In some newer distros this might work as well if MySQL is set up as a deamon/service.
But the question is really impossible to answer without knowing your particular setup.
flindebergflindeberg
4,0731 gold badge18 silver badges33 bronze badges
I assume you are looking to use mysql client, which is a good thing and much more efficient to use than any phpMyAdmin alternatives.
The proper way to log in with the commandline client is by typing:
Notice I did not type the password. Doing so would of made the password visible on screen, that is not good in multi-user environnment!
Ncus Login To Terminal
After typing this hit enter key, mysql will ask you for your password.
Once logged in, of course you will need:
to do anything.
Good-luck.
stefgosselinstefgosselin
7,1715 gold badges33 silver badges62 bronze badges
At the command prompt try:
give the password when prompted.
Tim Cooper
124k32 gold badges252 silver badges233 bronze badges
quarkoniumquarkonium
I had the same exact issue on my ArchLinux VPS today.
mysql -u root -p just didn't work, whereas mysql -u root -pmypassword did.
It turned out I had a broken /dev/tty device file (most likely after a udev upgrade), so mysql couldn't use it for an interactive login.
I ended up removing /dev/tty and recreating it with mknod /dev/tty c 5 1 and chmod 666 /dev/tty. That solved the mysql problem and some other issues too.
user789877user789877

Ncus Login To Terminal Number

To stop or start mysql on most linux systems the following should work:
The other answers look good for accessing the mysql client from the command line.
Good luck!
baraboombaraboom
  1. you should use mysql command. It's a command line client for mysql RDBMS, and comes with most mysql installations: http://dev.mysql.com/doc/refman/5.1/en/mysql.html
  2. To stop or start mysql database (you rarely should need doing that 'by hand'), use proper init script with stop or start parameter, usually /etc/init.d/mysql stop. This, however depends on your linux distribution. Some new distributions encourage service mysql start style.
  3. You're logging in by using mysql sql shell.
  4. The error comes probably because double '-p' parameter. You can provide -ppassword or just -p and you'll be asked for password interactively. Also note, that some instalations might use mysql (not root) user as an administrative user. Check your sqlyog configuration to obtain working connection parameters.
ceziocezio
if u got still no access to db, 1. in ur error message is set no password right?then first do mysqlpasswd 'username'after that enter and then give it a password type again as requested and then try to access again with mysql -p if you are root
user2807050user2807050
if you're already logged in as root just
prompting the password will otherwise return as error
maiomanmaioman
11.9k4 gold badges24 silver badges36 bronze badges
UdiUdi
vadiraj jahagirdarvadiraj jahagirdar

Not the answer you're looking for? Browse other questions tagged mysqllinuxlogin or ask your own question.

Legacy Platforms » Helcim Virtual Terminal »
1) To login to your account, go to the Helcim login page and select 'Helcim Virtual Terminal'. You will be asked to enter your Account ID and password. These will be provided to you in your 'Welcome to Helcim!' email.
2) The very first time you login to your account, you will be required to change your password. Your password must also change every 45 days. You cannot use the same password as previously used 13 times before. Please note your password must be a minimum of 7 characters which must include one upper case letter and one number.
3) When prompted by the system to change your password, enter your temporary password and create and confirm your new password.
4) Error- Account ID or Password incorrect- try the following:
-Make sure you are using the ACCOUNT ID.
-Do not copy and paste the temporary password- try typing it out.
-Make sure there are no additional spaces before or after any of the login information.
-For security reasons- you are unable to use any of the previous 13 passwords you have already used.

Ncu Learners Portal

-Your password must contain at least 8 characters, have one upper case letter and one number.
-Try resetting your password to something simple that you will remember- Ex. Winter2016!

Ncu Email Address

Next Step - Configuring Automatic Email Receipts