I have installed MySQL but I cant get it to work. My book says type “service mysqld start” but it doesnt work, nor do 2 other options it gives. Other advice talks about a repository. I have no idea what this is or whether to use one or how to use one.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Repository is place (server) where programs (packages) are stored. When you use commands like apt-get install, it’ll download requested package from repository.
Storage unit depends of context you use it. Your server (Droplet) comes with SSD. Available space depends on Droplet size you select.
DigitalOcean has great tutorial base. How To Install MySQL on Ubuntu 16.04 will help you set up MySQL on Ubuntu 16.04. How To Install MySQL on Ubuntu 14.04 will help you if you use Ubuntu 14.04.
Thank you, your answer was helpful, half-way. I now realise that I do not have to think about repositories at all in installing. Your recommended “How to install Mysql on ubuntu 14.04” was much clearer than other guides, until almost the end, when I got this:
The prompt is: (my name)@(myname-desktop):~S I type: mysql The output is: ** ERROR 1045 (28000): Access denied for user ‘mrwright’@‘localhost’ (using password: NO)**
Why should it deny access for root? Why should it not use my password when I have just created a password for root and used it several times in the course of the setting-up? I hope you can tell me where to go from here!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.