So I'm new to this whole SQL business but I took a course at school that deals with web programming and so on so now i'm thinking of cooking up something with MySQL instead of writing everything into a JSON document and saving it somewhere instead.
So here's the problem I've been having. I'm in PHPMyAdmin and I'm used to using XAMMP and how it lets you do everything so first off I want to create a sub account under my account that's spicifically for logging into the MySQL servers and dealing with login duties, saving and loading and just querying the MySQL service and that's it. However I have no idea how to do this since i cant just make another account.
Second I'm used to doing things with a GUI instead of typing out SQL commands and doing things that way and from the looks of it, there's no way of creating a new table using the limited GUI of whatever PHPMyAdmin version that is provided by the Cpannel. I am assuming that all this is for security purposes probably.
TL;DR: I want to make a SQL Accesses account to manage the stuff that has to do with SQL instead of my master account and I want to make a new database and put new tables into it.
So here's the problem I've been having. I'm in PHPMyAdmin and I'm used to using XAMMP and how it lets you do everything so first off I want to create a sub account under my account that's spicifically for logging into the MySQL servers and dealing with login duties, saving and loading and just querying the MySQL service and that's it. However I have no idea how to do this since i cant just make another account.
Second I'm used to doing things with a GUI instead of typing out SQL commands and doing things that way and from the looks of it, there's no way of creating a new table using the limited GUI of whatever PHPMyAdmin version that is provided by the Cpannel. I am assuming that all this is for security purposes probably.
TL;DR: I want to make a SQL Accesses account to manage the stuff that has to do with SQL instead of my master account and I want to make a new database and put new tables into it.