SQLSetup

Steps

Add a new user

1. Open SQL Server Management Studio. Use standard login
2. Under security, right click the Logins folder. Click "New Login.."
3. Type in a login name
4. Click "SQL Server authentication"
5. Type password and confirm password
6. Uncheck enforce password policy
7. Click OK

Allow for remote connection

1. Right click on the current database connection (Eg. "(local) (SQL Server 11.0.2100")
2. Click properties
3. Click Security on the "Select a page" menu
4. Click SQL Server and Windows Authentication mode

• Restart the database
  1. Open the start menu and type "run". Click on the first program that is displayed
  2. Type SQLServerManager11.msc and press enter (or in the start menu type SQL Server Configuration Manager)
  3. Click "SQL Server Services"
  4. Right click SQL Server (SERVICENAME)
  5. Click restart
• Verify Connection
  1. Open an new instance of SQL Server Management Studio
  2. Click the drop down next to Authentication, select Sql Server Authentication
  3. Type in the username and password you used in the previous steps
• Initial Setup is Complete!
• If problems persist, change the tcp/ip to a static port mode
  1. Open SQL Server Configuration Manager
  2. Click on SQL Server Network Configuration
  3. Click on Protocols for SQLSERVER
  4. Ensure TCP/IP is Enabled
  5. Double click TCP/IP
  6. Click on the IP Addresses tab
  7. Scroll to the bottom, and under IPALL set TCP Dynamic Ports to empty, and TCP Port to 1433
  8. Restart SQL Server again
• Continue with setup here

Setup MySql

Create User

1. Open a MySql SQL editor (either through the workbench or in the terminal)
2. Create a user on localhost

CREATE USER 'userName'@'localhost' IDENTIFIED BY 'mypass';

1. Grand all access to this user

GRANT ALL PRIVILEGES ON * . * TO 'userName'@'localhost';

1. If making the server public, repeat the steps above for '%' instead of 'localhost'
2. Verify the connection by testing the login in the terminal (Or continue here if using windows)

mysql -u userName -p

1. If using Linux, MySql must be started in case insensitive mode. See here for instructions.