Create user and database and grant access

PHOTO

Fri Jun 11 2021 14:23:59 GMT+0000 (Coordinated Universal Time)

# If your logged in to mysql (mysql -u root -p) you can create the database
#CREATE DATABASE database_name;
CREATE DATABASE <database> CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';

# The user can be created with
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'user_password';

# This user also needs access to the database
GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';

# To make the new access rights available you have to reload them
FLUSH PRIVILEGES;

COPY

Save snippets that work from anywhere online with our extensions

Comments

Typo3

@dphillips

Set the environment context for TYPO3 Disable mySQL strict mode Use image as overlay mask for opacity for another image via imageMagick Create user and database and grant access xdebug configuration for server and vscode Show PIDs in page tree Cookiebot Google Consent Mode Backup using tar

Wordpress

@dphillips

Store database credentials from wp-config in shell variable Change Wordpress URL Create user and database and grant access xdebug configuration for server and vscode Cookiebot Google Consent Mode add_action in wordpress Backup using tar

Shell/Bash

@dphillips

Store database credentials from wp-config in shell variable Use image as overlay mask for opacity for another image via imageMagick Create ssh-key Deploy ssh key to remote server Create user and database and grant access Create symlink Create restricted user xdebug configuration for server and vscode Sync with rsync Backup using tar

MySQL

@dphillips

Disable mySQL strict mode Create user and database and grant access Save database dump

#pyproj #python #database #path

Fix pyproj database path

 """ 
'UserWarning: pyproj unable to set database path.' <- This happens with multiple pyproj installations on the same machine, which is quite common, as almost every geo software depends on it.

How to fix:
First, find all copies of 'proj.db' on the machine. Get the path for the correct one, which is probably something like 'C:/Users/Clemens Berteld/.conda/pkgs/proj-8.2.0-h1cfcee9_0/Library/share/proj'. Definitively not a QGIS or PostGIS path.

Then, use it as a parameter for this function and run it at the top of your code:
"""

def set_pyproj_path(proj_path):
    from pyproj import datadir
    datadir.set_data_dir(proj_path)
    # print(datadir.get_data_dir.__doc__)

#sql #database #querying-data

SQL Select all columns with GROUP BY one column

https://stackoverflow.com/a/39816161/6942743

#prestashop #delete #mysql #db #database #ids

Delete from DB if not in array

Db::getInstance()->executeS("DELETE FROM product_images WHERE id_product NOT IN (" . join($allProductIds,',') . ")")

#wordpress #database #credentials #automate

Store database credentials from wp-config in shell variable

WPDBNAME=`cat wp-config.php | grep DB_NAME | cut -d \' -f 4`
WPDBUSER=`cat wp-config.php | grep DB_USER | cut -d \' -f 4`
WPDBPASS=`cat wp-config.php | grep DB_PASSWORD | cut -d \' -f 4`

#database #mysql

Create user and database and grant access

# If your logged in to mysql (mysql -u root -p) you can create the database
#CREATE DATABASE database_name;
CREATE DATABASE <database> CHARACTER SET 'utf8mb4' COLLATE 'utf8mb4_unicode_ci';

# The user can be created with
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'user_password';

# This user also needs access to the database
GRANT ALL PRIVILEGES ON database_name.* TO 'database_user'@'localhost';

# To make the new access rights available you have to reload them
FLUSH PRIVILEGES;

#php #codeigniter #database #model

Query Builder for database CI

https://codeigniter.com/userguide3/database/query_builder.html

#php #codeigniter #database #model

Shortcuts in Model CI

$sql = "SELECT * FROM some_table WHERE id = ? AND status = ? AND author = ?";
$this->db->query($sql, array(3, 'live', 'Rick')); // insert in ci

#php #codeigniter #database #model

Validate in Codeigniter

$this->load->library("form_validation");
$this->form_validation->set_rules("username", "User name", "trim|required");
if($this->form_validation->run() === FALSE)
{
     //$this->view_data["errors"] = validation_errors();
}
else
{
     //codes to run on success validation here
}

#database

Count group by date

SELECT count(*) as application, YEARWEEK(created_date) as weekNum
FROM nepaldevjobsapplication
GROUP BY YEARWEEK(created_date)

#database

Chat DB Design

Inbox
id, userId(holder of this account), senderId, lastMessage

Chat
id, senderId, recieverId, message, seen, deleted

//
DB query when inbox is opened
findall where userId = senderId or userid = receiverId

#python #mysql #database #thirdparty

My SQL Connection

#!/usr/bin/python



-- coding: UTF-8 --


pip install MySQL-python



import MySQLdb, os




try:
    conn = MySQLdb.connect(host='172.17.42.1', user='my_email', passwd='normal', db='database', port=3306)




cur = conn.cursor()
cur.execute('SELECT `id`, `name`, `path`, FROM `doc_file`')

# results
resulsts=cur.fetchall()    id, name, path = r[0], r[1], r[2]

    if path and not os.path.exists(path):
        print 'file not exist: ', id, name, path, flashpath

cur.close()
conn.close()

 



except MySQLdb.Error,e:
     print "Mysql Error %d: %s" % (e.args[0], e.args[1])




</pre>

#database #postgresql #nodejs #indiafirst #javascript #pgadmin4

PostgreSql-> Table exist check query

SELECT EXISTS (
   SELECT FROM information_schema.tables 
   WHERE  table_schema = 'public'
   AND    table_name   = 'abcd'
   );

#database #postgresql #nodejs #indiafirst #javascript #pgadmin4

html to pdf download working

import { jsPDF } from "jspdf";

export default async function lead({
}) {

  const doc = new jsPDF('p', 'pt', 'a4');
  doc.setFontSize(12)
  doc.html(document.getElementById("dream-house-full"),  {
    useCORS: true,
    autoPaging:'text',
    // html2canvas:
    callback: function (pdf) {
      pdf.save("12.pdf");
    },
    html2canvas: {
      scale: 0.5,
      // ignoreElements: element => element.id === autoTableConfig?.elementId,
    },
    x:10,
    y:10,
    width:1400,
  });
  // doc.save("a4.pdf");

  // htmlPdf.create(html, options).then((pdf) => pdf.toFile('test.png'));
}

#laravel #database #eloquent #model

db-models-and-eloquent

https://github.com/LaravelDaily/laravel-tips/blob/master/db-models-and-eloquent.md

#mysql

mysql - What are these files ,can I delete them manually? - Server Fault

[root@jiaoyou mysql]# pwd
/var/lib/mysql
[root@jiaoyou mysql]# ls -ls
338256 -rw-rw---- 1 mysql mysql 346030080 2010-04-22 08:08 ibdata1
626812 -rw-rw---- 1 mysql mysql 641222072 2010-01-26 07:17 mysql-bin.000008
316892 -rw-rw---- 1 mysql mysql 324173772 2010-03-25 12:51 mysql-bin.000009
52724 -rw-rw---- 1 mysql mysql  53931666 2010-04-12 12:13 mysql-bin.000010
10136 -rw-rw---- 1 mysql mysql  10359639 2010-04-22 08:32 mysql-bin.000011

mysql> SHOW BINARY LOGS; 
+------------------+-----------+
| Log_name         | File_size |
+------------------+-----------+
| mysql-bin.000008 | 641222072 | 
| mysql-bin.000009 | 324173772 | 
| mysql-bin.000010 |  53931666 | 
| mysql-bin.000011 |  10360680 | 
+------------------+-----------+


Solution

PURGE BINARY LOGS TO 'mysql-bin.010';

Create user and database and grant access

Save snippets that work from anywhere online with our extensions

Comments

More like this

Typo3

Wordpress

Shell/Bash

MySQL

Browse more snippets >>

Create user and database and grant access

Save snippets that work from anywhere online with our extensions

Comments

More like this

Typo3

Wordpress

Shell/Bash

MySQL

Browse more snippets >>

Embed code snippet