developer resources
Codebales holds an ever growing number of solutions to problems that we have experienced in our day to day code writing
Selected filter
24
results
Andrew Fletcher
•
On your local OSX environment using Terminal or iTerm you can create a MySQL database, database user, and password, as well as, assign all privileges to the user for the database.
Knowing your credentials, before beginning you will need to know the following:
user: {user}
password: {password}
database: {database}
For my local environment, I'll be using these credentials
user
root
password
root
database
safs
Walkthrough the steps to build your database:
The initial step is to...
Andrew Fletcher
•
This article assumes that you are running Docker and Lando already. Don't...
Andrew Fletcher
•
Running Docker and attempting to install a web proxy environment where I'm...
Andrew Fletcher
•
Working on an Azure server I ran a mysqldump command to generate a copy of the...
Andrew Fletcher
•
When attempting to backup mysql using the mysqldump command
mysqldump -u root...
Andrew Fletcher
•
How to Create New MySQL User
Before you can create a new MySQL user, you need to open a terminal window and launch the MySQL shell as the root user. To do so, enter the following command:
sudo mysql –u root –por rather than typing sudo each time you can enter:
sudo su
mysql -u root -pIn either scenario next type in the root password and press Enter.
The prompt will change to
mysql>
Database list
Can you view the list of databases on the server using the following command:
SHOW...
Andrew Fletcher
•
The generally accepted answer to a mysqldump is:
mysqldump -h [host] -u...
Andrew Fletcher
•
To add ejabberd and run MYSQL to the server I needed to update the server...
Andrew Fletcher
•
The starting point is to read through and follow the notes outlined on the...