PureBasic Forums - English

Code: Select all

UseMySQLDatabase()

; You should have a server running on localhost
;
If OpenDatabase(0, "host=localhost port=3306 dbname='test'", "user", "password")
  Debug "Connected to MySQL"
Else
  Debug "Connection failed: " + DatabaseError()
EndIf

Code: Select all

CompilerIf #PB_Compiler_OS = #PB_OS_MacOS

  Procedure.s GetAppPath()
    Protected bundlePathPtr = CocoaMessage(0,CocoaMessage(0,CocoaMessage(0,0,"NSBundle mainBundle"),"bundlePath"),"UTF8String")
    If bundlePathPtr
      Protected bundlePath.s = PeekS(bundlePathPtr,-1,#PB_UTF8) + "/"
    EndIf
    ProcedureReturn bundlePath
  EndProcedure
  
  ; ---------------------------------------------------------------------------------------
  
  Procedure.s GetResourcePath()
    Protected bundlePathPtr = CocoaMessage(0,CocoaMessage(0,CocoaMessage(0,0,"NSBundle mainBundle"),"resourcePath"),"UTF8String")
    If bundlePathPtr
      Protected bundlePath.s = PeekS(bundlePathPtr,-1,#PB_UTF8) + "/"
    EndIf
    ProcedureReturn bundlePath
  EndProcedure
  
  ; ---------------------------------------------------------------------------------------
  
  
  libdb.s = GetAppPath() + "Contents/Library/libmariadb.dylib"
    
  If UseMySQLDatabase(libdb) = 0
    Debug "Error MySQL"
    MessageRequester("Error", "libmariadb.dylib not found!")
    End
  EndIf
  
CompilerElse
  
  libdb.s = GetPathPart(ProgramFilename()) + "libmariadb.dll"
  
  If UseMySQLDatabase(libdb) = 0
    Debug "Error MySQL"
    MessageRequester("Error", "libmariadb.dll not found!")
    End
  EndIf
  
CompilerEndIf

Code: Select all

UseMySQLDatabase("libmariadb.dylib")

; You should have a server running on localhost
;
OpenConsole()

If OpenDatabase(0, "host=localhost port=3306 dbname='test'", "user", "password", #PB_Database_MySQL)
  PrintN("Connected to MySQL")
Else
  PrintN("Connection failed: " + DatabaseError())
EndIf

CloseConsole()

Code: Select all

Connection failed: Plugin caching_sha2_password could not be loaded: dlopen(lib/mariadb/plugin/caching_sha2_password.so, 0x0002): tried: 'lib/mariadb/plugin/caching_sha2_password.so' (no such file), '/System/Volumes/Preboot/Cryptexes/OSlib/mariadb/plugin/caching_sha2_password.so' (no such file), '/usr/lib/lib/mariadb/plugin/caching_sha2_password.so' (no such file, not in dyld cache), 'lib/mariadb/plugin/caching_sha2_password.so' (no such file)

Code: Select all

g***@mac ~ % /bin/bash -c ‘$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/HEAD/install.sh)’

Code: Select all

g***@mac ~ % brew install mariadb-connector-c

Code: Select all

;For macOS only!

CompilerIf #PB_Compiler_Processor=#PB_Processor_Arm64
 #HomebrewPath$="/opt/homebrew/"
CompilerElse 
 #HomebrewPath$="/usr/local/"
CompilerEndIf

SetEnvironmentVariable("MARIADB_PLUGIN_DIR",#HomebrewPath$+"lib/mariadb/plugin/")
UseMySQLDatabase(#HomebrewPath$+"lib/mariadb/libmariadb.dylib")

#Database=0

If OpenDatabase(#Database, "host=localhost port=3306 dbname='test'", "root", "")
 Debug "Connected to MySQL"
 DatabaseUpdate(#Database,"DROP TABLE IF EXISTS Persons")
 DatabaseUpdate(#Database,"CREATE TABLE Persons (LastName varchar(255), FirstName varchar(255))")
 DatabaseUpdate(#Database,~"INSERT INTO Persons (FirstName,LastName) VALUES (\"John\",\"Doe\")")
 DatabaseUpdate(#Database,~"INSERT INTO Persons (FirstName,LastName) VALUES (\"Jane\",\"Smith\")")
 If DatabaseQuery(#Database, "SELECT * FROM Persons")
  While NextDatabaseRow(#Database)
   Debug GetDatabaseString(#Database,1)+" "+GetDatabaseString(#Database,0)
  Wend  
  FinishDatabaseQuery(#Database)
 EndIf
 CloseDatabase(#Database)
Else
 Debug "Connection failed: "+DatabaseError()
EndIf

Code: Select all

g***@mac ~ % brew install mysql

Code: Select all

g***@mac ~ % mysql.server start                    
Starting MySQL
 SUCCESS! 
g***@mac ~ % mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 9.0.1 Homebrew

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE test;
Query OK, 1 row affected (0,01 sec)

mysql>

Code: Select all

g***@mac ~ % arch -x86_64 /bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"
g***@mac ~ % /usr/local/bin/brew install mariadb-connector-c