Find the answer to your Linux question:
Results 1 to 4 of 4
Hi there everybody. I'm fairly new to linux. I have previosly used windows and Gui's like php Myadmin to access my db. I have installed MySQL on my debian and ...
  1. 11-10-2011 #1
    akimelit
    akimelit is offline
    Just Joined!
    Join Date
    Oct 2011
    Posts
    36

    How to run start and run MySQL

    Hi there everybody.
    I'm fairly new to linux.
    I have previosly used windows and Gui's like php Myadmin to access my db. I have installed MySQL on my debian and i'm having a little trouble starting MySQL on my system. What is the correct way to start MySQL trough your terminal. I have tried the following ( as root user in linux not Mysql ). in the shell i have typed mysql root and i was hoping for it would ask me of my password but it didnt.

    Is there a better way to run MySql in a debian ? Mayby trough a gui.
    I would even though like to also be able to access it trough my shell.

    Thanks in advance guys.
    Reply With Quote Reply With Quote
  2. 11-10-2011 #2
    elija
    elija is offline
    Trusted Penguin elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    2,298
    If you are talking about the client then as a normal user simply run
    Code:
    mysql -u root -p
    on the computer where the server is running, which will ask for the MySQL (not Linux) root user password. If you have configured a different user then you can substitute that for root. You won't see the cursor moving when entering a password!

    If you are talking about the server, then you start it by running
    Code:
    sudo /etc/init.d/mysqld start
    and you can see if the server is running by using
    Code:
    ps aux | grep mysql
    Last edited by elija; 11-10-2011 at 11:45 AM. Reason: Spotted one typo. There may be others.
    If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)


    My new blog. It's probably not as good as I think it is.
    Reply With Quote Reply With Quote
  3. 11-10-2011 #3
    elija
    elija is offline
    Trusted Penguin elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    2,298
    As for GUIs, there should be mysql administrator and mysql query browser in the repositories and you can download the Ubuntu 10.04 .deb file from the mysql website for Workbench. This worked OK when I installed it and your mileage may of course vary. Of course you could always build from source. Which is interesting when you get a compiler error!
    If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)


    My new blog. It's probably not as good as I think it is.
    Reply With Quote Reply With Quote
  4. 11-10-2011 #4
    akimelit
    akimelit is offline
    Just Joined!
    Join Date
    Oct 2011
    Posts
    36
    : ) Thans elija. I was now able to log on as i wanted. Really apprechiate your help.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

...