Perfect-MySQL library not found for -lmysqlclient for architecture x86_64 with Xcode & brew

1. install mysql

$ brew install mysql

2. make xcodeproj

import PackageDescription
let package = Package(
    name: "PerfectTemplate",
    targets: [],
    dependencies: [
        .Package(url: "https://github.com/PerfectlySoft/Perfect-HTTPServer.git", majorVersion: 3),
        .Package(url: "https://github.com/PerfectlySoft/Perfect-MySQL.git", majorVersion: 3)
    ]
)

swift package generate-xcodeproj
open [yourproject].xcodeproj

3. Xcode build and Error

Xcode -> Product -> Build
library not found for -lmysqlclient for architecture x86_64

Solution

swift build -Xlinker -L/usr/local/lib
swift test -Xlinker -L/usr/local/lib
swift package -Xlinker -L/usr/local/lib generate-xcodeproj

Refers

• https://github.com/IBM-Swift/SwiftKueryMySQL#install-mysql